Replace null with max of date value in date column

Question

Hi,

I have date field and it contains null values. I need to replace null with max of date value. How to do it.

Please help.

Example

Date

12-03-2022

13-03-2022

14-03-2022

15-03-2022

I need to replace null or empty record by max date that is 15-03-2022.

AngelosPachis · Accepted Answer

Hi @Sharat055 ,

Use a summarize tool to find the max value in your date field and append it back to your data. Then with a formula tool, check if the cell values are null and if they are, use the max date taken from the summarize tool

Hope that helps,

Angelos

Qiu · Accepted Answer

@Sharat055 
Just try another approach. A bit length though. 😁