If the user has a different time zone, how can I find out the time zone for a specific date field?

MayurGavhane · ‎09-22-2023

Hello All,

I am using UI Formatter(Schedule Date Range Selector) for Date range selection as I have attached picture above.

I have set the time to between 8:00 and 9:00AM,Although each user's timezone is different, it displays the same for them all.

How can I get what field is using for the time?

Thanks.

-O- · ‎09-22-2023

The parent Schedule is most likely configured for floating time zone.

Change it to a fixed time zone.

View solution in original post

-O- · ‎12-12-2023

Can you share the script?

Setting field schedule to the parent schedule's unique value (sys_id) will attach the entry to the parent schedule.

Once that is done the schedule dot-walk will also correctly show the parent schedule's TZ.

As for generating the entries through script, as long is there is an algorithm to know the periods, should be possible, but before being able to tell for sure, that logic must be shared.

I mean fiscal periods are generated by script.

B.t.w, if you have fiscal periods in your instance you could have a look at that code, it should get you started.

View solution in original post

-O- · ‎09-22-2023

The parent Schedule is most likely configured for floating time zone.

Change it to a fixed time zone.

MayurGavhane · ‎09-25-2023

@-O- Thanks for the reply.

I have added Time Zone field on the form but when I select any specific time zone and try to save It did not get save showing "--Floating--" only.

-O- · ‎09-25-2023

You need to configure the time zone on the parent record.

To easily find the parent record, you need to add a different field to the form: Schedule.

Once on the form, you need to go to the referenced (parent) Schedule and set the time zone there.

MayurGavhane · ‎09-27-2023

Hi @-O-

I have added parent field on the form which refer to 'sys_user' table please check the below picture, but having same problem after save or update the Time Zone field value showing '--Floating--'

Or I am doing anything wrong?