Convert day name to day number

Question

I have fields holds day name like "Saturday" or "Wednesday".. etc

I need to convert it to day number, so "Saturday" becomes 6 and Wednesday becomes 3.. etc

I was able to do the opposite, convert day number to day name, but not the vice versa.

what would you suggest ?

TheOC · Answer

Hi @b_sab

Very similar to @atcodedog05's if/else statement, but I managed with a switch/case, which I personally much prefer for use-cases like this as I find them cleaner, but result is the same:

Hope this helps!

b_sab.yxmd

atcodedog05 · Answer

Hi @b_sab

Even i looked it to check is there a way Wednesday can be converted to a date and then a week day number.

Using DateTimeParse but seems like only DateTimeFormat can handle weekdays but DateTimeParse doesnt handle weekdays. Apparently

b_sab · Answer

Thanks. the problem is i have the values in fields and not planning to create new rows. was looking if there is a formula to do that. might need to stick with IF ELSE solution