Formula for date on or before last Friday
Hello, I need a formula for date on or before last Friday.... If([PAYROLL START DATES] on or before last Friday, "RED", "#FFFFE0") thank you ------------------------------ BuildPro --...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend//try this
var date MyDate = [PAYROLL START DATES];
var number DaysToSubtract = Case(DayOfWeek($MyDate),
0,2,
1,3,
2,4,
3,5,
4,6,
5,0,
6,1);
var date LastFriday=
$MyDate - Days($DaysToSubtract);
If([PAYROLL START DATES] <= $LastFriday,
"RED",
"#FFFFE0")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var date MyDate = [PAYROLL START DATES];
var number DaysToSubtract = Case(DayOfWeek($MyDate),
0,2,
1,3,
2,4,
3,5,
4,6,
5,0,
6,1);
var date LastFriday=
$MyDate - Days($DaysToSubtract);
If([PAYROLL START DATES] <= $LastFriday,
"RED",
"#FFFFE0")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- What should this be? $MyDate
------------------------------
BuildPro
------------------------------- It's not colorizing some of the dates?
------------------------------
BuildPro
------------------------------
- this is incorrect:
this is correct
------------------------------
BuildPro
------------------------------- MarkShnier__Youtry this vesion
//try this
var date MyDate = [PAYROLL START DATES];
var number DaysToSubtract = Case(DayOfWeek($MyDate),
0,2,
1,3,
2,4,
3,5,
4,6,
5,7,
6,1);
var date LastFriday=
$MyDate - Days($DaysToSubtract);
If([PAYROLL START DATES] <= $LastFriday,
"RED",
"#FFFFE0")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Ummmm. Didn't work
------------------------------
BuildPro
------------------------------
