on 03-13-2019 10:15 AM
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
current date = trunc(sysdate)
Currnet date+7= trunc(sysdate)+7
similar for 14 and 21.
check below link for more conditions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.