on 05-25-2017 11:57 AM
Hi All,
In my HANA calculation view, i have an input parameter and it is based on column ""meth_date" of my calculation view and it is a mandatory variable. Now i need to take the date field entered in this input parameter then negate 1 with it to get the "Previous date".
The second input paramter must have a value (Entered date - 1).
Is this possible ?
Yes, this is possible . Create one Input Parameter based on "Procedure/Scalar Function" . Whatever date your users are entering will go to the procedure and procedure would return you 'Previous Date" . Your data would be filtered with that . Check this blog post, this is written for month but you can use the same approach ( in fact much easier) for date .
Code to get previous date is as below :
END_DATE := TO_DATS (add_days( :INPUT_DATE ,-1)) ;
Cheers
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT ADD_DAYS (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), -30) "add days" FROM DUMMY;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.