Forum Discussion
if statement returns true instead of date
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
do you even read what i write?
this query will never return a date because you have >= in your "then" part. Do you want to return "FINISH_DATE" or do you want to substract something? I still don't know which date you want to return 😄
BR
sorry i missed your question i apologize for that- Basically, it to return Finish Date plus Today Plus 1 as in one day into the future
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
No need to apologize, I was just wondering 🙂
But I still don't really get it. Could you add some sample date?
E.g. FINISH_DATE='2022-09-30' - what do you want to return?
Or do you want to return some date (then which date) if FINISH_DATE is greater than today+1?