Compare user date to system date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im having problems with comparing a user defined date to the system date.
What I am attempting to do is to see if the system date is within 60 days of
the user defined date (CDL_Exp_Date). Any help on this would be greatly
appreciated.

Thanks

c_ascheman
 
What I am attempting to do is to see if the system date is within 60
days of the user defined date (CDL_Exp_Date).

If Abs(DateDiff("d", Date(), CDL_Exp_Date)) > 60 Then
' it's too far away

Else
' it's pretty close

End If


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Colour code dates 1
error on update table WHERE date comparison 0
Countif 3
Date programming question. 6
Excel Formula - Count Dates from another Sheet 8
Excel Excel Show Countdown Date 7
Compare dates 2
Opening form based on 2 values. 3

Back
Top