HI
I need to create a calculated column with the below formula in Dataverse column
Case(DayOfWeek([Date]),
0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday")
Date: Time zone issue.
Can you please guide me how can i achieve the above in Model driven app or dataverse table calculated column.
Many Thanks
SG
Hi @SG013
I used Power FX in the Dataverse formula columns.
The first thing is that this date column must have the format in the "Time Zona Adjustament" property only in Date Only for the formula to work.
Then you can use the following formula
If(Weekday(Fecha)=1,"Sunday",If(Weekday(Fecha)=2,"Monday",If(Weekday(Fecha)=3,"Tuesday")))