Last day of the month

Avatar

Avatar

ashleym1988

Avatar

ashleym1988

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)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

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)

Avatar

Avatar

saikatk2447661

Avatar

saikatk2447661

saikatk2447661

13-09-2018

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")