compare 2 columns and get max date

Answered

Follow

shiva Karat

• January 23, 2020 21:05

can you please let me know how to do the below

 

I have below requirement can you tell me how to do it in datameer

 

Column_A(Date)    Column_B(Date)   My_Column Null  Null Null Null Date Date Date Null Date
Date                      Date                       Max of 2 date   If column A and Column B is null My_Columns should be Null If column A is Null and Column B has a date My_Columns should be Date If column A has a Date and Column B is null My_Columns should be Date If Both Column A and Column B has Dates in it then My_Column should bring Max of those 2 Dates.     Date  Format :- Jan 31,2019 12:00:00:00

0

• 

  Konsta Danyliuk

  • January 24, 2020 13:43

  Hello Shiva.
  Let's try with the following dataset - two columns with date values.

  

  If you will introduce the formula IF(#ColA > #ColB; #ColA; #ColB) to MyColumn, you will get there:

  • The latest date of ColA and ColB if both columns have values.
  • The date from the one column if another has no value.
  • Null if both ColA and ColB have no values.

  

  Does this satisfy your requirements?

  1

  Comment actions Permalink
• 

  shiva Karat

  • February 06, 2020 16:21

  Thank you Danyliuk

  0

  Comment actions Permalink

Please sign in to leave a comment.