since ‎19-03-2015
‎10-12-2019
OlyChristine
Level 1
Re: How to get field to advance to the 1st of the next month
Avatar

OlyChristine

OlyChristine
- Adobe LiveCycle
syntax error near token 'do'I should be able to figure this out, Friday brain, but I feel it's close.

Views

61

Likes

0

Replies

0
How to get field to advance to the 1st of the next month
Avatar

OlyChristine

OlyChristine
- Adobe LiveCycle
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

Views

193

Likes

0

Replies

3
Re: Calculate age (years and months) from two dates
Avatar

OlyChristine

OlyChristine
- Adobe LiveCycle
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!!

Views

580

Likes

0

Replies

0
Re: Calculate age (years and months) from two dates
Avatar

OlyChristine

OlyChristine
- Adobe LiveCycle
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...

Views

475

Likes

0

Replies

0
Calculate age (years and months) from two dates
Avatar

OlyChristine

OlyChristine
- Adobe LiveCycle
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!

Views

1.3K

Like

1

Replies

6
Likes given to
Likes from