Creating date objects for a universe

building semantic layer
1

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 :uk: (BOB member since 2009-02-21)

2

There’s a STICKY TOPIC for that. 8)

3

Thanks Mark - has everything but the next quarter

MattK :uk: (BOB member since 2009-02-21)

4

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

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

MattK :uk: (BOB member since 2009-02-21)

5

Looks good to me.

Use the code tags to format your code btw -

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