Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

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]
Tue, 08/19/2008 - 12:41am
a.mahesh197's picture
a.mahesh197
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

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
  • Login to post comments
  • 21581 reads
Tue, 08/19/2008 - 1:43am
#1
Lepa's picture
Lepa
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

Top
Tue, 08/19/2008 - 10:09am
#2
Lepa's picture
Lepa
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

Top
Sat, 08/23/2008 - 9:50am
#3
Nitin's picture
Nitin
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

Top