NOW time off by 2 hours

[Heather_Mann]

Not sure if this is a bug, or if it’s because the NOW is getting the date/time from the server (shared host). If it’s getting it from the server, is there a way to get the users local date/time in a server connect?

What I need to do is set a field create_date to the date/time when the user created the record, in their local time. I’m using NOW and it’s currently recording it as two hours later than my local time.

Thanks.

[Teodor]

Hello
NOW in server connect uses the server time, not the user local time.
You can use NOW_UTC instead and store the time in UTC time zone instead.

Or you can take the users local time from the front end, using the Date and Time component and store its value into some hidden field:

Working with Current Date and Time

In Wappler there is a component called Date and Time. As its name suggests, it returns the current date and time. In this tutorial we will show you how to access it, configure and use it on your pages. First, as any other component, in order to access the current date and time you need to include the component in app structure. Click the add new component button: [Screenshot_16] Open Data and select Date And Time: [Screenshot_17] In the properties inspector you can select the refresh inte…

[Heather_Mann]

Got it. Thanks.