Answered

date format not displaying correctly in CDS table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Experiencing an issue with date format and how dates are being stored in a CDS table.

Using now() from a canvas app which is performing a patch to a table, the date is being stored in a MM/dd/YYYY format, and not a dd/MM/yyyy format. This is then being returned and displayed back in the canvas app in the incorrect format.

Just wondering how to format this column in the CDS table so that it stores the date in a dd/MM/yyyy?

Can't seem to find any info on this.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Prakash4691 1,332 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In model driven app, while creating date time field we cannot change the format. It will save values in mm/dd/yyyy format.

To change the format we can modify in personal options of user. so that format will be displayed based on short date format (it depends on region). I selected English-India.
If you don't want to change in MDA, instead modify in canvas app. It is simple and reliable.

Change the datacardvalue format property of date field to same as in MDA. FYR attached screenshot.

Regards,
Prakash

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

To answer your original question, dates in Dataverse are being stored as UTC with the following format:

Date Time: yyyy-mm-dd'T'HH:mm:ss'Z'
e.g. 2019-12-10T00:31:13Z

Date: yyyy-mm-dd
e.g. 2019-12-10

More on date behaviors: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/behavior-format-date-time-attribute

Hope this helps...

Was this reply helpful? Yes No
Fubar 8,528 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

CDS is UTC, now() may not be, you need to tell now() what format i.e. UTC when you update CDS. See the UpdateContext in the solution of the following post https://powerusers.microsoft.com/t5/Building-Power-Apps/Eastern-Time-Zone-Using-Now-Function/td-p/17833

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi all, i have actually found a resolution to this.
As i was returning CDS data into a data table, i ended up enabling under Advanced Settings -> 'Enable improved data table control selection and value property'.

From there, i was able to format the date column in my data table to a dd/mm/yyyy format, like below:

Text(ThisItem.date_column,"[$-en]dd-mm-yy hh:mm AM/PM")

Thanks all for the replies

Was this reply helpful? Yes No