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:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati

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.
5 + 12 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.