Formatting UK Dates in Canvas Apps from CDS date columns.

I have been working with Canvas Apps and CDS recently this page is dedicated to all those things I keep looking up about formatting dates.

Display CDS date column as UK date as text

Text(ThisItem.DOB, "dd/mm/yyyy")

Displays as 25/10/2020

Text(ThisItem.DOB, "dddd mmmm yyyy")

Displays as Sunday April 1976, notice only the day of the week shows, to show both the number and the text of a day use the following:

Text(ThisItem.DOB, "dddd dd mmmm yyyy")

This displays the date as Monday 22 October 2018

Text(ThisItem.DOB, "dd mmm yyyy")

Displays as 04 Apr 1976

Text(ThisItem.DOB, "dd mmmm yy")

Displays as 04 April 76

Leave a Reply

Your email address will not be published. Required fields are marked *