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 question in SQR

  • Post reply
2 replies [Last post]
Mon, 12/14/2009 - 8:48am
Guest's picture
Guest

Hi All,

I have date issues in the SQR AS Shown below
one value is AGE-LIMITSTUD=2009-03-03(birthdate+Age-limit)
and another one is (currentdate-30) 14-NOV-2009 .when i compare these two dates it is not working properly.
I can use Edit option which format i need to change these two dates two compare b'cause one is getting (2009-03-03 and another one is 14-NOV-2009 ) please help me on this.

Thanks in advance
sudha

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
Mon, 12/28/2009 - 1:03pm
#1
Guest's picture
Guest (not verified)
Re: date question in SQR

Convert them to stings and compare strings.

Top
  • reply
Wed, 01/13/2010 - 2:26am
#2
Radha's picture
Radha (not verified)
Re: date question in SQR

hi,
Use the "edit" function to convert the date to the desired format and use the "strtodate" function to conver to date format before comparing.

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.