Beginning of month issues

[joshrussin]

It is now the first of the month and am trying to pull some data from yesterday. I have been using this formula to get the latest working date, but it gets the latest working date for the month. I would like to be able to pull data from yesterday as well even though it was a different month, but has to have the time conversion in it as well. Any help?

=(Sum({$<Date_Emp={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays)))"}>} (Actual_Emp / FTE_Emp)))

[sunny_talwar · Accepted solution]

What date do you see when you use this in a text box object?

=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00')-1,1,$(vHolidays))

[joshrussin]

My coworker put the wrong dates in the database. All is good. Thanks for pointing that out.