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
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

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

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.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
2 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.