ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compare Current Date (https://www.excelbanter.com/excel-programming/303930-compare-current-date.html)

InnerChild[_2_]

Compare Current Date
 
I feel silly for not being able to figure this out.

How do I compare the users current system date, to a date I arbitaril
pick.

I'm making a calculator that will need to be updated every 6 months o
so. I want to make a box pop-up when they open the calculator after sa
December 31, 2004, directing them to our website for an update.

How can I do this? Thank

--
Message posted from http://www.ExcelForum.com


gitcypher[_32_]

Compare Current Date
 
If Date #12/31/2004# Then 'Date is the current system date
MsgBox "You need to download the updated version"
End If

-Gitcyphe

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com