Skip to Content
0

Sap HANA functions

Jul 01, 2017 at 10:57 AM

63

avatar image

In the calculation view for particular column (say) effective date

I need to set condition for that field( I.e)effective date) as : effective date should be greater than the system date and the column effective date is of type date

So can we create a calculated column as curr_ date where the filter expression would be date(now()) and the data type is date

Now for the effec_date column can the condition be set as effec_date >= curr_date

Is this correct?

Need to implement in calculation view and not at the sql end

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers