MIN & MAX

[Ariz]

Hi all

I am just trying to put min or max formula to identify prior and current date as I have two different COB dates

Have put something like this

IF[Close of Business date]= MAX THEN "CURRENT" ELSE "PRIOR" ENDIF

but doesn't seem to be working

Please share your thoughts

thanks
Ariz

[JosephSerpis]

Edit: that syntax would not work as you described

[Jonathan-Sherman]

Hi @Ariz,

So you'll want to bring a summarise tool in using a MAX action and append that back to your original data (using an append fields tool). This will create you a new column (of the max date in the data set) which can then be used in a formula tool expression.

I'll mock up a quick example.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[Jonathan-Sherman · Accepted solution]

Attached is an example workflow,

if this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[Ariz]

Thanks Jonathan it worked