Hi Jeff - here are some notes on time zones and queries etc:
KnowledgeSync's standard date substitution variables (e.g., {%Current Date%}, {%Current Date Time%} capture the date/time on the current server and thus cannot natively be used to calculate elapsed times and/or the date/time when records have been created or modified.
Vineyardsoft's Support Dept has documented the process whereby you can make a minor edit to all existing KnowledgeSync queries to correctly interpret and calculate date values stored in UTC format.
1) You need to calculate the number of hours your local KnowledgeSync server is offset from UTC (GMT). Jeff for your install which is Summit / East Coast USA your UTC offset would be 5 hours
2) To get the "current time" (in UTC/GMT format) on the KnowledgeSync server, you would use the following expression in a KnowledgeSync query:
DATEADD(HOUR,5,'{%Current Date Time%}')
3) To get the "current date" (in UTC/GMT format) on the KnowledgeSync server, you would use the following expression in a KnowledgeSync query
DATEADD(HOUR,5,GETDATE())
These functions will add 5 hours to the current local time and will yield the current time in UTC/GMT format.
------------------------------
Marc Cregan
Technology Integrators
------------------------------