# Compare two custom fields with native field

**URL:** <https://community.eazybi.com/t/compare-two-custom-fields-with-native-field/2392>\
**Category:** Questions & Answers\
**Created:** [June 21, 2019, 12:56pm UTC](https://community.eazybi.com/t/compare-two-custom-fields-with-native-field/2392 "2019-06-21T12:56:20Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![lakshmi](https://community.eazybi.com/letter_avatar_proxy/v4/letter/l/ea5d25/32.png) [@lakshmi](https://community.eazybi.com/u/lakshmi)\
**Post date:** [August 3, 2021, 6:37pm UTC](https://community.eazybi.com/t/compare-two-custom-fields-with-native-field/2392/3 "2021-08-03T18:37:34Z")

</div>

Hi Martin,  
How to Compare Multiple date fields and find the latest date among them and output string based on latest date. Example: PCR received date, PCR responded date and Agreed requirements date .  
if PCR recevied date is latest date compared to other date fields then i want status to be ‘PCR received’.  
if PCR responded is latest date compared to other dates than i want status as ‘PCR Responded’.  
if Agreed requirements date is latest compared to other dates than i want status as ‘Reqs Agreed’  
Please assist

---

_[View the full topic](https://community.eazybi.com/t/compare-two-custom-fields-with-native-field/2392)._
