/scripts/ahub.form.attachments.js
0

Date Condition in webi not working

Oct 18, 2016 at 05:55 AM

13

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content