Q&A BY TAG '#date #datedifference'

You must sign in to ask a question. If you do not have an account, you can register here

Subtracting a no from a date DATEDIFF(dd,0,b.pymt_run)
answered 21-11-2019 16:05:22 -0500

Can you please help me to convert following statement in denodo DATEADD(dd, CASE WHEN DATEDIFF(dd,0,b.pymt_run)%7 > 4 THEN 7-DATEDIFF(dd,0,b.pymt_run)%7 ELSE 0 END,b.pymt_run) as fin_pymt_run Here b.pymt_run is of date datatype. Thank you!

Answers: 3

#date #datedifference