Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, in my board I would like to show the day name extracted from today()
based on the name of the day, i would like to have different "work hours" to use for my calculations.
How can I do this?
EXAMPLE:
If the day is Monday, workHours= 22
Tuesday, workHours= 24
Wednesday, workHours= 24
Thursday, workHours= 24
Friday, workHours= 23
Saturday/sundays, workHours= 0
Hi, function WeekDay() will provide you day of week
We can represent it with number (from 0 to 6) for easier understanding with num(WeekDay(today()))
So you can use simple if() to get your your worksHours:
if( num(WeekDay(today()))=0, 22,
if( num(WeekDay(today()))>0 and num(WeekDay(today()))<=3, 24,
if( num(WeekDay(today()))=4, 23, 0)))
Hi, function WeekDay() will provide you day of week
We can represent it with number (from 0 to 6) for easier understanding with num(WeekDay(today()))
So you can use simple if() to get your your worksHours:
if( num(WeekDay(today()))=0, 22,
if( num(WeekDay(today()))>0 and num(WeekDay(today()))<=3, 24,
if( num(WeekDay(today()))=4, 23, 0)))
Thank you so much, it worked