Hi. I am using the data view web part to help format list items by comparing a custom date column to the current date. I get the current date by using the $Today parameter that is set by the data view web part from a CAMLVariable parameter.
I have set the site's timezone to GMT so I was expecting $Today to come back as GMT. But it is not, $Today is coming back using the server's timezone which is PST. The problem is, we don't have access to the server so we can't change the timezone. Also,
because the $Today date is coming back in PST it means it's impossible to compare it to the dates in the list items which are coming back in GMT.
Has anyone had this problem?
Myles Jeffery | Thinkscape |
SharePoint Online Deployment
SharePoint Online File Migration Tool
View Complete Post