Last day of the month | Community
Skip to main content
ashleym1988
ashleym1988
Level 2
September 13, 2018
Solved

Last day of the month

  • September 13, 2018
  • 2 replies
  • 3880 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    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

    2 replies

    saikatk2447661
    saikatk2447661
    Level 4
    September 13, 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")

      Amit_Kumar
      Amit_KumarAccepted solution
      Level 10
      September 17, 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

        Terms & ConditionsAccessibility statement

        Loading footer...