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

Date Calculation question "Designer"

Craig-MDS
Level 1
Level 1

I have a Date/Time field Called "RecievedHO"

I have a second field Called "QuoteDate"

I am trying to have QuoteDate display "RecievedHO" date plus 14 days

RecievedHO is a dropdown calandar option as an example you select 1/08/16 (format = dd/mm/yy)

I have QuotedDate (Text field) as FormCalc set on calculate*

I have

form1.#subform[0].Subform1.QuoteDate::calculate - (FormCalc, both)

RecievedHO + 14

if i select "1/08/16" then it should give a result of 15/08/16  instead i get "14"

Any held would be great

I have gone through the search questions but nothing seems to work.

Thanks

1 Reply
TehnologiaInformatiei
Level 2
Level 2

Hello Craig-MDS,

Check out this sample I made for you.

http://bit.ly/2c7ZwGG

I hope it helps.