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

3 replies [Last post]
a.mahesh197's picture
User offline. Last seen 12 years 6 weeks ago. Offline
Joined: 08/19/2008
Posts: 6

Hi,
How can i can change the date format in SQR

Lepa's picture
User offline. Last seen 2 years 5 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: date format in SQR

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

Lepa's picture
User offline. Last seen 2 years 5 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: date format in SQR

You can also look at datetostr and strtodate functions.
example:

Let $date_string = strtodate ($mydate, 'YY/MM/DD')
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

Nitin's picture
User offline. Last seen 5 years 29 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: date format in SQR

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