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
this is incorrect:
this is correct
------------------------------
BuildPro
------------------------------
this is correct
------------------------------
BuildPro
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendtry 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
------------------------------
//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
------------------------------ - Here's an updated version that computes last Friday using today instead of the payroll date. Try this:
var Number daysToSubtract = If(DayOfWeek(Today()) = 6, 1, 2+DayOfWeek(Today()));
var Date lastFriday = Today() - Days($daysToSubtract);
If( [PAYROLL START DATES] <= $LastFriday,
"RED",
"BLUE")
------------------------------
Doug Henning
------------------------------
