how fix "must have arguments of the same type"

User: "AbbasZavar22"
New Altair Community Member
Updated by Jocelyn
Hi there,

I wanna calculate the range between two dates less than 3 months:
I made it as

if(date_diff(PerformedDate,LatestDate<7,776,000,000),1,0)

3 months = 7,776,000,000 milisec

But I get an error as "must have arguments of the same type"
Both date are the same date format.

Any recommendations?



Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "BalazsBaranyRM"
    New Altair Community Member
    Accepted Answer
    Hi!

    date_diff() takes two date/time attributes. You are passing "LatestDate<7" as the second parameter, that would be a boolean result.

    This would be a syntactically correct form of the formula:
    if(date_difff(PerformedDate, LatestDate) < 7776000000), 1, 0)

    Numbers must be specified without the thousands separators in the formula.

    Regards,
    Balázs
    User: "AbbasZavar22"
    New Altair Community Member
    OP
    Perfect, much appreciated Balázs