Last day of the month | Community
Skip to main content
ashleym1988
ashleym1988
New Participant
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

    Amit_Kumar
    Amit_KumarAccepted solution
    New Participant
    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

      saikatk2447661
      saikatk2447661
      New Participant
      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")

        Terms & ConditionsAccessibility statement

        Loading footer...