Question

8
Replies
4933
Views
GowriD25 Member since 2015 9 posts
NJ Courts
Posted: May 2, 2016
Last activity: May 19, 2016
Closed

Report Definition Current Date time SQL function

We are using the OOTB CPM alert functionality. This has a report definition "GetCPMAlerts". This report definition filters out all the alerts that are applicable for the current day.

This uses a SQL function "Current Date Time", and this returns the time in GMT which is a problem.

Since all the user are in the US the GMT does not work properly . Is there an alternative solution for this problem

Thanks

Gowri

Message was edited by: Marissa Rogers - added category

Reporting
Moderation Team has archived post
Share this page LinkedIn