Creating date objects for a universe

[system]

Hi

I have just created some objects for Last Day Of Next Month using last_day(add_months (sysdate,1)) however i now need to create something similar for first day of next quarter and last day of next quarter.

Any help willl be greatly appreciated

Regards
Matt

---

MattK (BOB member since 2009-02-21)

[MarkP]

There’s a STICKY TOPIC for that. 8)

[system]

Thanks Mark - has everything but the next quarter

---

MattK (BOB member since 2009-02-21)

[system]

Would this do the job for last day of the next quarter

add_months(trunc(sysdate,‘q’),6)-1

---

MattK (BOB member since 2009-02-21)

[MarkP]

@MattK

Would this do the job for last day of the next quarter

add_months(trunc(sysdate,‘q’),6)-1

Looks good to me.

Use the code tags to format your code btw -

add_months(trunc(sysdate,'q'),6)-1