Does there exists any routine to compare two date

Mahua Mitra · New User Joined: 26 Apr 2007 Posts: 49 Location: Delhi

Hi

Does there exists any routine to compare two dates?

Thanks

enrico-sorichetti · Posted: Fri Oct 26, 2007 3:53 pm

it depends on the date format/declaration

if the dates have the same format/same declaration
and the order is yyyy,mm,dd

then a straight comparison will be ok

if the format/declaration is different then You must convert to the same
format

Mahua Mitra · New User Joined: 26 Apr 2007 Posts: 49 Location: Delhi

Thanks

enrico-sorichetti · Posted: Fri Oct 26, 2007 4:33 pm

Just a clarification,
when the date is a character string the separators ( if there ) must be the same

yyyy-mm-dd will be different from yyyy/mm/dd

murmohk1 · Posted: Fri Oct 26, 2007 6:31 pm

Mahua,

Most of the shops maintain inhouse DATE COMPARISION subroutine/tool. Speak with your peers, they might offer some help.