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

2 replies [Last post]
Guest's picture

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

Guest's picture
Guest (not verified)
Re: date question in SQR

Convert them to stings and compare strings.

Radha's picture
Radha (not verified)
Re: date question in SQR

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