How can i compare to dates formatted through long date?? A string comparision happens if they are in variables and that doesnt work right for dates
Printable View
How can i compare to dates formatted through long date?? A string comparision happens if they are in variables and that doesnt work right for dates
Have you tried using the DateDiff function?
Returns a Variant (Long) specifying the number of time intervals between two specified dates.
Syntax
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
Hope this helps.
Michael