Calculate First and Last day previous month in IDT

[former_member573008]

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.

[Joe_Peters]

Single-source or Multisource? If single-source, what's the underlying database?

[former_member573008]

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

Regards,

Iv.

[jyothirmayee_s]

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