Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

OlyChristine
Community profile OlyChristine Level 1
Job title here
Location here
5 BADGES
Level 1

Level 1

Learn more
Joined the community 19-03-2015 11:26:50 AM
Offline
Top badges earned by OlyChristine
Customize the badges you want to showcase on your profile
Re: How to get field to advance to the 1st of the next month
Avatar
Give Back 3
Level 1
OlyChristine
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
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

108

Likes

0

Replies

0
How to get field to advance to the 1st of the next month
Avatar
Give Back 3
Level 1
OlyChristine
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
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

244

Likes

0

Replies

3
Re: Calculate age (years and months) from two dates
Avatar
Give Back 3
Level 1
OlyChristine
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
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

700

Likes

0

Replies

0
Re: Calculate age (years and months) from two dates
Avatar
Give Back 3
Level 1
OlyChristine
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
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

596

Likes

0

Replies

0
Calculate age (years and months) from two dates
Avatar
Give Back 3
Level 1
OlyChristine
Level 1

Like

1 like

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
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.4K

Like

1

Replies

6
Likes given to
Likes from