FirstWorkDate calculating backwards

[george55]

Hi all,

Have this formula in the load script:

If(TimeStampField > FirstWorkDate(Today(), 1, $(Holiday)), '-1 Day',  ....

TimeStampField will be used in a filter pane. Output of this formula is (let's say today is March 18) all data from March 18. What I need is all data from March 17. That means Today - 1 Day = March 17. March 18 should be skipped. If I use this formula:

If(TimeStampField > FirstWorkDate(Date(Today() -1), 1, $(Holiday)), '-1 Day',  ....

then got as result all data from March 17 and 18. How can I avoid the todays date (March 18)? Need only days from March 17.

Thanks.

[sunny_talwar]

Not sure, but may be this

If(TimeStampField > FirstWorkDate(Date(Today() -1), 1, $(Holiday)) and TimeStampField <> Today(), '-1 Day',  ....

[george55]

Good idea, but unfortunately have the same result.

[sunny_talwar]

Would you be able to share a sample where we can see the issue

[george55 · Accepted solution]

Find the solution.

When using a '<>' then the values on both sides must have the same value. Timestamps are not suitable for that. Adjusting the values on both side with Floor() helped.