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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.