Hi All,
I have a scenario where I need to have a formula that looks at all of the dates and picks up the earliest/first one as the "Initial Enquiry’. However not all of the fields are filled in there are fields that are empty as not everyone was enquiring for the particular developments.
I have this formula:
MIN(
VALUE(DATETIME_FORMAT({Date Field #1},‘YYYYMMDD’)),
VALUE(DATETIME_FORMAT({Date Field #2},‘YYYYMMDD’)),
VALUE(DATETIME_FORMAT({Date Field #3},‘YYYYMMDD’)),
VALUE(DATETIME_FORMAT({Date Field #4},‘YYYYMMDD’)),
VALUE(DATETIME_FORMAT({Date Field #5},‘YYYYMMDD’)),
VALUE(DATETIME_FORMAT({Date Field #6},‘YYYYMMDD’))
)
However, it doesn’t seem to capture the empty fields hence it is giving ‘error’ as the result.
So what is required is for a formula to look for those 6 fields, eliminate those empty fields and then look for the earliest date. Is this formula possible?
