Date format to dd/mmm/yyyy

(0) Share

Report

Posted on by Open1333

Hi,

I have a SharePoint List log in date column data type: date and time,

I know below code to display: 19/Sep/2023

Text(Today(),"dd/mmm/yyyy")

but however it is in data type: Text, is it possible to display date in this format "19/Sep/2023" in data type: date and time?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello,

If you are always looking for 3 characters of the month you can do this. You can change DateValue(add your string date), or if you have a real date, just put the data there and take out DateValue() or you can put utcNow() etc.

Concatenate( Text(DateValue("01/01/2023"),"dd"), "/", Left(Text(DateValue("01/01/2023"),"mmmm"),3), "/", Text(DateValue("01/01/2023"),"yyyy") )

Example:

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @Open1333 ,

Do you want to format the date column in a SharePoint list?

If so please try JSON Schema

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "span", "txtContent": "=getDate([$DateColumn]) + '-' + if(getMonth([$DateColumn])==0,'Jan',if(getMonth([$DateColumn])==1,'Feb',if(getMonth([$DateColumn])==2,'Mar',if(getMonth([$DateColumn])==3,'Apr',if(getMonth([$DateColumn])==4,'May',if(getMonth([$DateColumn])==5,'Jun',if(getMonth([$DateColumn])==6,'Jul',if(getMonth([$DateColumn])==7,'Aug',if(getMonth([$DateColumn])==8,'Sept',if(getMonth([$DateColumn])==9,'Oct',if(getMonth([$DateColumn])==10,'Nov','Dec'))))))))))) + '-' + getYear([$DateColumn])" }

Best Regards,

Bof

Was this reply helpful? Yes No
Open1333 81 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for your help!!
I want to display the date in below format
but my SharePoint List column data type: Date and Time

Was this reply helpful? Yes No