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
BedrockMission!

Learn More

View all

Sign in to view all badges

How do you subtract X number of weeks from a Date Field/

Avatar

Avatar
Level 1
Pbhul
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Pbhul
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
Pbhul
Level 1

06-07-2015

Looking for a Script for subtracting X number of weeks from a Date Field.

Presently, Date Field is named RTL, Number of Weeks Numerical Filed is named NumericalField6.

Result Filed is aDtae field named DSPSE.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Level 1
Pbhul
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Pbhul
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
Pbhul
Level 1

07-07-2015

DSPSE=Num2Date((Date2Num(RTL.formattedValue,"MM/DD/YYYY")-NumericField6*7),"MM/DD/YYYY")

I am using FormCalc to get durations(weeks)  from a given date and working back to obtain other Milestone dates.

Getting aprompt message everytime I add a duartion " Validate DSPSE".

Thanks.

Pbhul

Avatar

Avatar
Springboard
MVP
Magus069
MVP

Likes

143 likes

Total Posts

1,077 posts

Correct Reply

155 solutions
Top badges earned
Springboard
Validate 1
Ignite 3
Ignite 1
Establish
View profile

Avatar
Springboard
MVP
Magus069
MVP

Likes

143 likes

Total Posts

1,077 posts

Correct Reply

155 solutions
Top badges earned
Springboard
Validate 1
Ignite 3
Ignite 1
Establish
View profile
Magus069
MVP

07-07-2015

Hi there,

Here are the best scripts to work with dates with JavaScript in LiveCycle Designer

Enjoy, hope this will help ya!

Adobe LiveCycle Designer Cookbooks by BR001: Date handling in Livecycle Designer ES forms