MIN & MAX

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

Common Use Cases

Accepted answers

Jonathan-Sherman

Attached is an example workflow,

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

Regards,

Jonathan

20200217 - MaxDate.yxmd

All comments

Edit: that syntax would not work as you described

Jonathan-Sherman

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

Attached is an example workflow,

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

Regards,

Jonathan

20200217 - MaxDate.yxmd

Thanks Jonathan it worked

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335