Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date column less than another date column

Hello,    I have 2 date columns and I want to figure out if date column A is less than date column B then show me date column A.    Also    If date column B is blank show me date column A.    ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

    Or If you want a measure: 

     

    Measure = IF(MAX([Date1])<MAX([Date2])||ISBLANK(MAX([Date2])),MAX([Date1]),BLANK())

     

    Best regards
    Paul Zheng

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

Or If you want a measure: 

 

Measure = IF(MAX([Date1])<MAX([Date2])||ISBLANK(MAX([Date2])),MAX([Date1]),BLANK())

 

Best regards
Paul Zheng

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, 

 

I used your formula however it now doesn't work? as for some reason it is showing me 31/12/2020 which is in neither column as shown below. 

 

"If 'Notified of Connection Date' is less than 'LegalsCompleteDate' then show 'Notified of Connection Date'

                                                                 
                                                                    AND     

 

"If 'Legals Complete Date' is blank show 'Notified of Connection Date'                       

 

Formula

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    Try remove ".Date " after each date columns.

     

    Best regards
    Paul Zheng

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank You 😄 It works now.