Jump to content
Macro Express Forums

Dates With Boolean Operators


sentinel_hawk
 Share

Recommended Posts

I have all the logic figured out about and the only question I have is if there is a command to check to see if a user prompted date if that date is older than either 90 days or say a year old. Is Ifvariable using Boolean operators going to work for dates or do I need to change it to days? Just looking for an easy option without having to dowload the functions that are mentioned in other threads.

Link to comment
Share on other sites

Hi,

More "MacroExpress" friendly, you can just import the DateDiff.mxe, gives date difference as %N1% (using vbscript)

if your local dates are "MM/DD/YYYY" instead of "DD/MM/YYYY" you will need to adjust lines 3 and 4

Date/Time: Save "dd/MM/yyyy" into %T11%

Date/Time: Save "dd/MM/yyyy" into %T11%

Then you can simply "If variable" compare on %N1%

Best, Randall

DateDiff.mxe

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.

Guest
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.

Loading...
 Share

×
×
  • Create New...