Problem with Date calc

[IDEAS-Training]

I'm trying to get this FormCalc calculation to work:

Date2Num (form1.Page1_SF.EffectDates.endDate, "M/D/YYYY") - Date2Num (form1.Page1_SF.EffectDates.startDate, "M/D/YYYY")

Evently, I will divide it by 7 to get the number of weeks, but the initial calculation does not want to work after entering in the dates.

Can you tell me what is wrong with my forumula?

Thank you.

[Former Community Member]

Do the date patterns on each date field match the date patterns on your calculation?

Steve

[IDEAS-Training]

Yes, here is the date pattern:

date{M/D/YYYY}

I'm looking at your PDF now.

[Former Community Member]

If you can forward the form to stwalker.adobe@gmail.com I would be happy to take a look.

Steve

[Former Community Member · Accepted solution]

Odd. Something strange about the Date2Num format. I changed them in the calculation to "YYYY-MM-DD" and it works. Note it is calculating the number of elapsed days.

if (HasValue(form1.Page1_SF.EffectDates.endDate) & HasValue(form1.Page1_SF.EffectDates.startDate)) then

$.rawValue = Date2Num(form1.Page1_SF.EffectDates.endDate.rawValue,"YYYY-MM-DD") -Date2Num(form1.Page1_SF.EffectDates.startDate.rawValue,"YYYY-MM-DD")

else

  $.rawValue = null

endif

Steve