Jump to content
Macro Express Forums

Tenure Date Check


Recommended Posts

Hey everyone, I was trying to figure if this works. I am trying to set something in a macro that checks the date of an account. Now i know how to get the date into a variable and i can set another variable for 6 months from todays date(would this need updated daily?) but is it possible to even compare these two variables or if there is another way to do it let me know.


For my project customers date has to be before todays date - 6 months ex. Today 11/11/2009 cust must be before 5/11/2009

T1 copied account date from customers info

T2 todays date minus 6 months

essentially want that N1 is going to be set to 0 and if customers date is not 6 months old change n1 to 1, if n1 = 1 then macro stop (well will be a fail and note out spreadsheet)


i was trying to figure ways to compare these two variables or even if there was a way to copy customers date and add 6 months must not be greater (future) todays date.


Thanks for any help

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...