Max(date)

[PaulTHR]

In Data Plans and in 'New calculated item'

I want to create a new category so I can display on its own the max date of a field (as in the latest submisison date is xx/xx/xxxx

Max [_ForAll_] ('submission_date'n)

I have tried the MAX operator but it states

I wish to make this available in my SAS Viya report but make the changes above in Data Plans.

I do not wish to use SAS code

Any ideas

Thanks

[JustinCase · Accepted solution]

The only way that I can come close to what you want is when I create the max date as a number:
Max [_ForAll_] (TreatAs(_Number_, 'Date'n))

[PaulTHR]

Thanks very much - that worked