User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
To Get The Last Day of Month & First Day of Month in SQR
Mon, 06/23/2008 - 10:46pm
#include datemath.sqc
#include datemath.sqc
!*****************************************
move &dateval to $dateval
show $dateval
do Format-DateTime($dateval,$Res_Date,{DEFCMP},'','')
show 'Res_Date'$Res_Date
move $Res_Date to $Res_Date1
let $Res_Date1 = substr($Res_Date1,1,4) || '-' || substr($Res_Date1,5,2)|| '-' || substr($Res_Date1,7,2)
show 'Res_Date1'$Res_Date1
do dtu-month-begin($Res_Date1,$start_dt)
do dtu-month-end($Res_Date1,$end_dt)
let $end_dt = substr($end_dt,9,2)||'-'||substr($end_dt,6,2)||'-'||substr($end_dt,1,4)
show 'endate' $end_dt
!***************************************
!***************************************
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Hi there,
Thanks for sharing the sample code. For your information, site members can share sample code by adding them as pages to the avaibale books. You will have to register to be able to do that.
Thanks again!
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Normally I just use a select from dual. But there are many ways to do it obviously.
begin-select
to_char(last_day(add_months(sysdate, -1)) +1,'MM/DD/YYYY') &first_DOM
to_char(last_day(sysdate),'MM/DD/YYYY') &last_DOM
from dual
end-select
Agree with you oddsnends and actually there is this post added not long ago that does exactly that, cheers!
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Hi,
I Thinks its performance issue hitting database everytime is not good wat i feel..
Just interms of SQR Related I posted this...
By the wat thanks for u r comments.....
Venkat
-------
Post new comment