User login
Sponsored links
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.
date format in SQR
Tue, 08/19/2008 - 12:41am — a.mahesh197
Hi,
How can i can change the date format in SQR
Bookmark/Search this post with:
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |
Re: date format in SQR
Join date: 06/23/08
Hi a.mahesh197 and welcome to the site :)
Take a closer look at the edit() function in SQR, it should do the trick.
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
Re: date format in SQR
Join date: 06/23/08
You can also look at datetostr and strtodate functions.
example:
Let $date_string = datetostr ($mydate, 'YY/MM/DD')
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
Re: date format in SQR
Join date: 06/30/08
How about using fucntion
FORMAT-DATETIME(&RH.RMA_DATE, $RMA_DATE, {DEFDATE}, '', '').
it'll format the date in the format set in pssqr.ini.
Thanks
Nitin Bhatia
Post new comment