Unanswered

Get weekday from number 0-6?

(0) Share

Report

Posted on by Cooper01

664

I'd like to convert a weekday stored as a number 0-6 as text value of a weekday. I thought I'd be able to use the text function to convert like this:

Text(0, "dddd")

to get value Sunday. Instead, regardless of what I have as the first parameter, the value returned (I'm using a label) is Wednesday. Is there any other way to make this conversion besides an If statement? (If(weekday = 0, "Sunday, If(weekday = 1, "Monday", ...)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

You can try Switch, here us a link to some info about Switch:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if

If you have already tried this and are looking for other potential solutions, let me know.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Cooper01 664 on at

Like (0)

Report

Thanks. I am aware of Switch too, I just wanted to make sure there wasn't a cleaner or built in way to make the conversion

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report
@Cooper01
You can use this formula

Set(YourNumber0Through6, 0); Text(DateAdd(DateValue("1/1/2017"),YourNumber0Through6,Days),"dddd")

I only used '1/1/17' because it is a Sunday. You can use any Sunday.
This also works, if it feels cleaner to you. Just replace the 0 with your value.
Text(DateAdd(DateValue("7"),0,Days),"[$-en-US]dddd")
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No