General Caster - Date formula miscalculating

Platform discussions monday apps & integrations
, ,
1

HI, I am using a formula that only works sometimes and I don’t know why.

I have a board with a bunch of registrations my team needs to complete. We track the date the request was received as well as the complete date.

I added General Caster and used a template to calculate the age of the request and subtract today from the request date and -1 to miss partial days, and once calculated to cast it to a number field.

I tested it out and when I put in dates from last week, the days active amount is correct. When I put dates in from last month or prior months, it is way off.. Examples:
June 10 2025 calc’d it as 16 days.
April 22 2025 calc’d it as 65 days
Nov 6 2023 calc’d as 64 days

I tried to wrap it in DATEVALUE and that didn’t fix it.

Below is my formula which successfully calculates if I use it in a formula field, but not in general caster’s automation. Figured I’d try here before reaching out to them.

IF(OR({State’s Date Registered} = “”, ISBLANK({State’s Date Registered})), ROUND(DAYS(TODAY(), {State’s Request Rcvd Date}) - 1, 0), ROUND(DAYS({State’s Date Registered}, {State’s Request Rcvd Date}), 0))

2

Hello!
Your date calculation formula, while working in a standard field, is likely failing in General Caster’s automation due to time zone discrepancies or how General Caster interprets date functions like TODAY() and DAYS() for older dates. The significant errors for dates from prior months suggest that the automation’s internal date handling differs from your expectations. The best next step is to contact General Caster support directly to inquire about their automation’s time zone settings and known issues with date calculations, providing them with your formula and examples.