Max in IF statement in load

[greend21]

I am trying to put the below calculation into my load so I can then use this flag in set analysis. Can this not be done? I keep receiving errors. I didn't think I would need a group by since Max is within the IF.

If(ReportDate>=Max(ReportDate)-5,1,0) as CADateFlag

[greend21]

In SQL it has to be formated like SQL SELECT CAST(Max(ReportDate)-5 as Date) but whether I do this or not I get the result in a date format.

[greend21]

I am getting a date just like in the database.

[olivierrobin]

date and time

can't this be the problem ?