Skip to Content
0
Former Member
Oct 18, 2016 at 05:55 AM

Date Condition in webi not working

53 Views Last edit Oct 18, 2016 at 05:55 AM 2 rev

FormatDate([Assignment Date dt]; "MM/dd/yyyy hh:mm:ss a") < FormatDate([NextBusinessDay]; "MM/dd/yyyy hh:mm:ss a") Then 1 Else 0

Even though assignment date is < Next Business Day the condition is still not met. Showing as ZERO

Assignment Date : 9/20/2016 8:46:49 AM

Next Business Day : 9/20/2016 6:00:00 PM