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
Was this helpful?
0 / 0