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
------------------------------
this is incorrect:
this is correct
------------------------------
BuildPro
------------------------------
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
------------------------------- MarkShnier__YouMaybe I am not understanding the result you were looking for. Could you post a spreadsheet with an example of today's date and some other dates for that payroll field and what color you expect the road to be?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------