Basic Date comparison

[lcrltd]

I am trying simply to see if a date entered is valid .
I.e. any date input is less than or greater than Today

Code: Select all

GetDate>vdate

Let>askdate=14/02/2016


if>askdate>vdate
mdl>greater than todays
else
mdl>lesser than todays
endif

But this only seems to look at the month portion and ignores the year.

[Marcus Tettmar]

I would use VBScript's DateDiff function:

Code: Select all

GetDate>vdate

Let>askdate=14/07/2011

VBEval>DateDiff("d","%vdate%","%askdate%"),daysDiff

If>daysDiff<0
  MessageModal>%askdate% is earlier than %vdate% (%daysDiff% days)
Else
  If>daysDiff>0
    MessageModal>%askdate% is later than %vdate% (+%daysDiff% days)
  Else
    MessageModal>%askdate% = %vdate%
  Endif
Endif