How to change time zone in Confiforms?

Hello community!

I am using a virtual function in Confiforms (https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions) to change the time format shown in TableView. It works well when using "created.formatDate(yyyy-MM-dd 'at' HH:mm z)" in the Field name. However, if I would like to change the time zone and set the field name as "created.formatDate(yyyy-MM-dd 'at' HH:mm z, UTC), it just became 13 digits numbers.

Could someone show me how to change the time zone in Confiforms? Thanks!

with NO time zone specified:

with specified time zone:

1 answer

1 accepted

0 votes

Answer accepted

Hi @Aster

You can use convertDate function to convert dates

Screenshot 2023-08-01 at 14.22.55.png Screenshot 2023-08-01 at 14.23.07.png

Alex

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Alex Medved _ConfiForms_

I've tried the convertDate function, but got the other series of weird numbers...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

btw, the field I'd like to use here is a reserved/internal field according to the following warning I got when trying to add a field definition in the form.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

It works fine for me as you can see - what ConfiForms version are you using?

As for the "reserved field name" error - nothing much to add. It is indeed a system field that every record has in ConfiForms and you cannot have your field with the name reserved for system (metadata) fields - https://wiki.vertuna.com/display/CONFIFORMS/Documentation