Forum Discussion
EmilyM2019
Helper II
Helper IIPicking a date from 2 columns
Hello all, This might be really simple but I am getting super confused / frustrated so any help would be appreciated. I have 2 date columns. What I am trying to do is to have a 3rd column...
EmilyM2019 , Not sure U i got it.
Create a new date column
Date new =coalesce([date1],[date2])
join this with Date of Date table
amitchandak
Super User
Super UserEmilyM2019 , Not sure U i got it.
Create a new date column
Date new =coalesce([date1],[date2])
join this with Date of Date table
EmilyM2019Helper II
Helper IIThanks, first time i've used COALESCE. Helpful tip.
- EmilyM2019
amitchandak this solution worked for this problem, but now I have a slightly different scenario.
I now have 2 columns with different dates and I want a new column that picks the date closest to todays date.
Example below. What formula do I need to calculate column C?
Regards,
Emily.