Automatic Expiry Date S’abonner

0
Avatar
Legacy Poster

Hello,

 

I have at template two cells:

 

date

expiry date,

 

I have choose date from "date picker", and this is a cell "date", "expiry date" i set from cell "date" with offset.

 

Expiry date is setting from current date, but not from date, which I choose, why?

1 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

It sounds like you haven't linked the two fields together and so the offset is being applied to the PCs system date.

 

In 2016 (there are probably other ways to do it, but I know this works): 

 

(For the Date Picker field I called this "pickeddate" rather than just "date" as this is could be used a function call)

 

For the expiry date field I set this as a "Date" Data Type and set up the offset from the Transforms tab making sure to tick to "Apply after Data Entry" and then on the Data Source tab set the Source to Visual Basic Script>Multi-Line Script and then used the Edit with Script Assistant button and changed the default line to 

 

Value =      

 

and then double clicked on the pickeddate Named Data Source name/icon in the right hand column which gave me

 

Value = Format.NamedSubStrings("pickeddate").Value

 

and then clicked Close to complete the setup.

Vous devez vous connecter pour laisser un commentaire.