Skip to Content
avatar image
Former Member

Date Condition in webi not working

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers