Crow Canyon Software Forum

Please or Register to create posts and topics.

Calculating dates based on other columns

#1 · October 5, 2021, 7:43 am

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.

Advice?

Thanks in advance

#2 · October 7, 2021, 1:27 am

Hi Kevin,

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

Syntax:
$add(([ColumnDisplayName|ColumnInternalName]),Days:Hours:Minutes:Seconds)

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