compare date fields

[Formzet_-_Zoete]

i have two date fields in different subforms.

the first must be older then the current date

and the second must be newer than the first date.

i tried to create a javascript to validate the fields, but i don't know how to do this

anyone?

[Former Community Member · Accepted solution]

The attached contains currentDate as a calculated field.

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

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

The exit events for the two date fields are as follows:

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

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

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

if (date1Num <= currentDateNum) then

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

endif

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

var date1Num = Date2Num(form1.page1.subform1.firstDate,"YYYY-MM-DD")

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

if (date2Num <= date1Num) then

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

endif

Is that what you are after?

Steve

[Formzet_-_Zoete]

Thank you.

This is exactly what is needed.

[Akyron]

How would you go about making the first date user entered (possibly the current date) and formatting it all to a MM/DD/YY?

[Akyron]

This is in Formcalc

How would you go about this same operation in Java?