cancel
Showing results for 
Search instead for 
Did you mean: 

how to create current date or sysdate condition in univers design tool (IDT)

rameshparchuri5
Participant
0 Kudos

Hi all,

how to create current date or sysdate variable in IDT.

based on that we need to display the next 7/14/21 days data in report . my universe point to Oracle DB.

can you please any one provide the logic for current/sysdate and next 7/14/21 days ( like ...sysdate+7..+14...)

please provide the syntax and example

universe version :

Information Design Tool 4.1 Build: 14.1.5.1501 Version: 4.1 Support Pack 5

Thanks,

Ramesh

TammyPowlas
Active Contributor

Thank you for your question; please note this question primarily relates to the Semantic Layer, so I changed your tag. Please be more careful when selecting your tags

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

current date = trunc(sysdate)

Currnet date+7= trunc(sysdate)+7

similar for 14 and 21.

check below link for more conditions.

http://www.forumtopics.com/busobj/viewtopic.php?t=139560