DateTime field calculation

[darth_pathos]

   Wow, second thread and it's only my first day!

I have a DateTime field that I'm trying to have validated so that the user cannot pick a date before today.  I know how to do it in Crystal Reports, Visual Basic, and a pile of other languages - but this one I'm stumped.

Here's all I've got.  Logic is very simple, but I'll be darned if I can get this to work!

if

(date2num(datetimefield1) - date2num(date()))<0 then messageBox("Test", "Wrong Date", 1, 0) elseif datetimefield1 endif

Thanks - any and all ideas are appreciated!

Chris

[Former Community Member · Accepted solution]

Here's what I have used...

// form1.page1.subform1.otherDate::exit - (FormCalc, client)

var currentDateNum = Date2Num(form1.page1.subform1.currentDate,"MM/DD/YYYY")

var dateNum = Date2Num($.rawValue,"YYYY-MM-DD")

if (dateNum <= currentDateNum) then

  xfa.host.messageBox("The date must be after the current date.")

endif

where

// form1.page1.subform1.currentDate::ready:layout - (FormCalc, client)

$.rawValue = Concat(Num2Date(Date(), "MM/DD/YYYY"))

Steve

[darth_pathos]

Hi Steve, thanks a million - that worked perfectly.  Appreciate your time!

Have a great one

Chris