hi All,
Want to use the following:
CASE
WHEN 'Next Cycle Count:' (basically this is a date coming up in the next few months)
only want to show the items that appear for next 30 days only
You might also consider using the Date Filter using the Next option. This allows you to do it without writing a beast mode.
Sorry…I'm in on a conference call…lol
CASE WHEN `NextCycleCount` >= CURRENT_DATE() AND `NextCycleCount` <= DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 'Show' ELSE 'Hide' END
ItemID,ItemName,NextCycleCount 1001,Widget A,2025-07-10 1002,Widget B,2025-07-15 1003,Widget C,2025-08-01 1004,Widget D,2025-07-08 1005,Widget E,2025-09-01 1006,Widget F,2025-07-25 1007,Widget G,2025-06-30 1008,Widget H,2025-07-05 1009,Widget I,2025-08-15 1010,Widget J,2025-07-29
CASE WHEN `Next Cycle Count` BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 'Upcoming in Next 30 Days' ELSE 'Outside 30 Days' END
This would give you a field you can use to list or filter.
CASE WHEN `Next Cycle Count` BETWEEN CURRENT_DATE() AND DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY) THEN 1 ELSE 0 END
any ideas "Calculation Error : This calculation contained an error.Calculation Error : This calculation contained an error."
re added teh 'Next cycle count' but still got the error
