Crow Canyon Software Forum

Forum Navigation
Please or Register to create posts and topics.

Calculating dates based on other columns

I have  a column called Ref Date

I also have a column called ExpirationDate

Expiration date should default to RefDate +45 days but still be an editable field by the user.

Every time I try something like this [[RefDate | RefDate]] +45 I get 45 years rather than days

I have tried %%[RefDate | RefDate]%%+45 with no luck.


Thanks in advance

Hi Kevin,

Please use add function in Custom Actions to add days to a date time column.


Ex: $add([RefDate|RefDate],45:0:0:0)