Forum Discussion
- QuickBaseCoachDQrew CaptainTodd, please copy and paste and post the actual code. I can't copy and paste to suggest edits to a screen shot, plus its too small to read.
Or else please courier some reading glasses to me. - ToddMolinoQrew Cadet
If(
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Red), "Red",
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Yellow), "Yellow",
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Green), "Green", ""
) - ToddMolinoQrew CadetLOL oh Mark..glasses on the way..NOT
- QuickBaseCoachDQrew Captaintry this
var bool IssueDateWasLastMonth =
IF(FirstDayOfMonth([Issue Date]) = FirstDayOfMonthAdjustMonth(Today(),-1),true);
// the above will be true if the 1st of the month of the issue date is the same date as the first of the month of the month previous to today.
IF(
Upper([Line]) <> "LIFE","",
$Red,"Red",
$Yellow,"Yellow",
$Green, "Green") - QuickBaseCoachDQrew CaptainI see I missed part of my formula!
IF(
Upper([Line]) <> "LIFE","",
not $IssueDateWasLastMonth,"",
$Red,"Red",
$Yellow,"Yellow",
$Green, "Green")