Skip to Content
0

Calculate First and Last day previous month in IDT

May 15 at 07:03 PM

66

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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

Regards,

Iv.

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A May 15 at 07:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded