Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
I am using custom record field to extract completedOnDate (custom field) from completedOn(date and time) field. But there are sceanrio where ,when I am changing time zone ,date returned is still in gmt but not according to user timezone because of this when I am quering like below,few extra work items are displayeda!queryFilter( field: 'recordType!{ee5aa46d-0228-430f-a794-1134a11fbcc0}CMGT_Task.fields.{d7e1c9a9-03ae-4bfd-bbe6-2edc7e8d915f}completedOnDate', operator: "=", value: today() ), How to fix this issue ,so that date is based on user timezone only and not in gmt
Discussion posts and replies are publicly visible
Simply use todate(local(fv!record.completedOn, timezone())) in a real-time custom record field.
Do you know whether Appian passes the locale of the user context into such an evaluation?
Appian stores all DateTime values in UTC. Custom record fields are evaluated in UTC during sync, not per user. As a result, extracting dates from DateTime fields at the record layer can cause timezone mismatches. The recommended approach is to perform DateTime range filtering using user-timezone functions like today() at query time rather than relying on derived date fields.
today()
Remove completedOnDate from filtering Filter using completedOn BETWEEN startOfDay AND endOfDay Convert DateTime → local timezone only in UI Avoid timezone logic in record sync
completedOnDate
completedOn BETWEEN startOfDay AND endOfDay