Last day of the month

ashleym1988

13-09-2018

Hi Guys,

I am trying to pull through the last day of the month within an email send in the format MM/DD/YYY however, I cannot find a function to do so. Is this possible? if so can someone point me in the right direction.

Thanks,

Ashley

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Kumar

MVP

17-09-2018

Hi Ashley,

You should add an enrichment and add the following attribute as an additional attribute for a date.

SubMinutes(AddMonths(YearAndMonth(GetDate()), 1), 1) as @lastDate

Then you can add a

formatDate(targetData.lastDate,"%2M/%2D/%4Y")

in your delivery.

Regards,

Amit

Answers (1)

Answers (1)