Does anyone know how i can turn date & time into day of week?
I am using Gallery to show my records and I have create date show in one of the fields i.e. 19/5/2020
Can I have another field that shows TUES?
Database: SharePoint
Hi @Anonymous ,
Do you want to display weekday of the corresponding date time value within your Gallery?
Based on the needs that you mentioned, I agree with @sayyed007amir 's thought almost. The Weekday() function could achieve your needs.
Please consider add a Label inside your Gallery, set the Text property of this Label to following:
Switch(
Weekday(ThisItem.Start),
1, "SUN",
2, "MON",
3, "TUE",
4, "WED",
5, "THU",
6, "FRI",
7, "SAT"
)
Note: The Start represents the Start Date time type column in your SP List, please replace it with actual column name
Please take a try with above solution, check if the issue is solved.
Best regards,
Hi @Anonymous
You can just add a label and call the Text function to apply a format that displays the day. This would be easier than calling the Weekday function and writing a Switch statement.
Text(ThisItem.Created, "ddd")
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1