Forum Discussion
LYeo87
Helper II
Helper IIDATE QUERY
Hi!
I have 2 columns which are pulling through dates - the first column is always earlier than the second.
Whats my best option to create a 3rd column which will pull back the data halfway between the 2?
@LYeo87 , Try a new column as
New Date to [date1] + datediff([Date2],[date1],day)/2
2 Replies
- amitchandak
Super User
@LYeo87 , Try a new column as
New Date to [date1] + datediff([Date2],[date1],day)/2
LYeo87Thank you! I'll give this a try!