Skip to main content
Question

How are timezones handled in NAC Data Tables DateTime columns?

  • 13 June 2024
  • 0 replies
  • 16 views

Question on datetime columns in Nintex Data Tables and timezones.

I can’t see any reference or configuration for timezone in either the table / column settings or in the documentation.

I’ll have forms that are AEST (Sydney) timezone. Do I need to do any timezone conversion when evaluating or storing the values?

As a use case I have a table ‘FormOpenClose’

which has columns for name, open (DateTime) and close (DateTime).

The idea being when the form loads it gather these values for a single row from the table and a form rule would control if the groups on form are visible and if the submit button works.

The tenant workflow regional settings are configured for Australia / Sydney as my timezone.

 

So a question of what timezone is used to store the datetimes in the table and what happens when we retrieve the values?

 

(@Chris_Ben thought I’d tag you on this post given the Data / Tables blog post you have written and you might have further info)

0 replies

Be the first to reply!

Reply