how fix "must have arguments of the same type"

AbbasZavar22

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?

BalazsBarany

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

AbbasZavar22

Perfect, much appreciated Balázs