I want to filter a report based on the CreatedDateTime and adjust for UTC. I have the filter working properly in the body of the report but how can I use it in the filter of the report overall?
Here’s what I want:
=dateadd([EPActivityApprove.CreatedDateTime],'h',-6) = Today()
or
as another option, how can I filter so [EPActivityApprove.CreatedDateTime] = Today(UTC)
Best answer by noorula77
Hi
try with below approaches:
There are 2 options - NowUTC() and TodayUTC() - available on reports that should use UTC time. I’ve never used them, so I can’t verify they work, but they should be available to select for both fields on the report and the report filters.
Hi
try with below approaches:
+13I'm guessing you're asking based on experiencing a need; however, I was fairly certain that Acumatica adjusts the returned CreatedDateTime based on the user's time zone. It's not stored that way, but I think it should be returned that way if the user's time zone / server time zone is correct.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
