I am trying to figure out how to get a date field (effDate1) to advance
to the first of the next month from the previous date field
(retireDate1). For example, if I enter 03/20/2015 in the field titled
retireDate1 - the next date field, titled effDate1, needs to be the 1st
of the following month - 04/01/2015. Any help is greatly
appreciated!!FormCalcDate Pattern: MM/DD/YYYY
GENIUS!!! At first it didn't quite work for me, it showed zero values
but did show this: 0 years 0 months. BUT then I looked at their
patterns, one of the cells was not set for the MM/DD/YYYY format - uh
der. I am so forever grateful to you and your brain. I may have one more
problem I'm trying to work out, separate from this, but I'll start a
different conversation.Again, thank you!!
I keep getting an error, I've set Age1 as a text field, and the other
two are date/time. Hmmm. I may just put this down for a bit and attack
it again with a clear head. I am hoping that whatever code I use, the
user would be able to enter the (formatted) date - MM/DD/YYYY in the
date/time fields., but I'm flexible. I was trying to modify the below to
fit my needs, but I know it's missing something, alas.if
(HasValue(DOB1)) then if (HasValue(retireDate1)) then var retireDate1_ =
Date2Num(retireDa...
Am trying get the (near accurate) age in years and months to populate in
"Age on date of retirement" (Age1) from the date of birth (DOB1) and the
date they retired (retireDate1). The only examples I've been able to
find are for "today" dates. Can someone help with code? And I understand
it works best with JavaScript but would FormCalc work also?Dates are set
as MM/DD/YYYYAge field is num{z9}Thanks in advance for your help!
