Question

8
Replies
5022
Views
Gowri Deivaraju (GowriD25)
NJ Courts

NJ Courts
US
GowriD25 Member since 2015 9 posts
NJ Courts
Posted: May 2, 2016
Last activity: May 19, 2016
Posted: 2 May 2016 22:51 EDT
Last activity: 19 May 2016 9:34 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.