Replace null with max of date value in date column

[Sharat055]

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

13-03-2022

14-03-2022

15-03-2022

15-03-2022

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

[AngelosPachis · Accepted solution]

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 solution]

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

[Sharat055]

Thank you so much for the reply, i will get back to you when i test it. 

[Sharat055]

Thank you so much for the reply. I will get back after i test it.