Last day of the month

[#1]

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

[#2 · Accepted solution]

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

[#3]

Try the following code.

var d=new Date();

d.setDate(1)

d.setMonth(d.getMonth()+1)

d.setDate(d.getDate()-1)

var date=formatDate(d,"%2M/%2D/%4Y")