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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Convert them to stings and compare strings.
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.