Max(Date) returns invalid expression

[43918084]

I have a table with field

  Date(Date#("ACCTG DATE (P0045)",'yyyyMMdd'),'YYYYMMDD') as "ACCTG DATE (P0045)"

 and I want to have a field to return latest date.

I used Max("ACCTG DATE (P0045)") and get invalid expression

Hope I can get some guidance

[43918084]

Thank you very much for your immediate help.

I have changed the script to Date#("ACCTG DATE (P0045)",'YYYYMMDD') as "ACCTG DATE (P0045)"

But when I apply max([ACCTG DATE (P0045]) I still have invalid expression unfortunately

[lorenzoconforti]

In which chart object are you getting  invalid expression? Can you share a screenshot?

[Mauritz_SA]

Hi @43918084 

You need another bracket max([ACCTG DATE (P0045)]).

If this doesn't work then please send a screenshot as @lorenzoconforti mentioned.

Regards,

Mauritz

[43918084 · Accepted solution]

Thank you very much Mr Agigliotti for your patience to help me many times.

I finally did an extra load and get the problem solved

left join
Load Max("ACCTG DATE (P0045)") as maxd
resident [LYCM];