Comparing of dates

Zelalem

Dear sir,

1. Is there any function used to compare dates in the same way as strings are compared ?
As in : Date 1= 11/22/2006
Date 2= 11/23/2006

Nov 22 '06 #1

albertw

Dear sir,

1. Is there any function used to compare dates in the same way as strings are compared ?
As in : Date 1= 11/22/2006
Date 2= 11/23/2006

hi

if (string) "Date 1" (rather no space in variables) is "11/22/2006"
you can use this directly

Nov 22 '06 #2

albertw

hi

if (string) "Date 1" (rather no space in variables) is "11/22/2006"
you can use this directly

hi

2ndly you can use DateDiff

date0 = "12/03/2006"
date1 = Format(Date, "dd/mm/yyyy")
diff = DateDiff("d", date0, date1)

Nov 22 '06 #3