Incorrect Date in CDS table

[Anonymous]

Hi,

I have a portal being used by external customers. The portal page has a form users use to create new records in my CDS table.

I have a custom logging software installed on the page that allows me to see the exact actions taken by the user on the page.

There are a number of date fields on the page, their date type in CDS is set to 'date only'

When a user selects a date on the form and submits the form, the date saved in the CDS table is always one day before what the user chose. Any idea what is going on here??

Thanks

Sam

[ragavanrajan]

Hi @Anonymous 

Looks like the date format time zone conversion settings needs to be changed. 

Please check the below official docs

https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/behavior-format-date-time-field 

You can also override the default date/time format to be used on portals by creating the following site settings:

• DateTime/DateFormat: The date format used on the portal.
• DateTime/TimeFormat: The time format used on the portal.
• DateTime/DateTimeFormat: The format for full date and time used on the portal.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

@ragavanrajan Thanks for the quick response.

According to that documentation, we should be using the Date Only type which we already are.
Per the doc: "The time portion of the value is always 12:00 AM. The value entered by one user is seen the same by other users in different time zones"

Yet the data that I have doesnt align with that explanation. See the following field called 'DOB'
It is set to date only:

Yet the values show with different times and for the wrong date. All these values were selected as one day ahead on the form

[Anonymous]

@ragavanrajan I understand what you mean now, under advanced settings these fields were set to 'User Local'. We will update to 'Date Only'

But im still trying to understand the logic here. How does it choose the time it sets? You can see from my example that the time is always set on the hour but sometimes a different hour. Basically I need a way to figure out which of these records are actually incorrect and which are correct. If they are all incorrect then I will have to go back through the database and mass update them all but I need a way of confirming this first. Any ideas? 

Thanks

[Anonymous]

I have found in the CDS table there is a field called 'Time Zone Rule Version Number'

There seems to be a correlation between this number and if my dates are correct or not.

For those with the version number of 4 the dates are correct. When it equals 0, they are incorrect. This is at least what it seems like to me but I dont have any way of checking it with all the data so I need some confirmation that this is correct before I go and fix everything.

Found this reference: https://joshimandarblog.wordpress.com/tag/timezoneruleversionnumber/