Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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
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
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