Skip to Content
avatar image
Former Member

Calculate First and Last day previous month in IDT

Hi Guys, please, I need to calculate the first and last day of a previous month for a giving date in IDT. Any help is much appreciated.

Regards,

Iv P.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 16 at 03:23 PM

    Hi Jyothirmayee , thanks for your feedback. I made little changes and It worked.

    Regards,

    Iv.

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 07:10 PM

    Hi,

    Try this formula in IDT:

    add_months(add_days((date-field),-extract(day from ( date-field ))),+1)

    You can also try LAST_DAY()

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded