Forum Discussion

LYeo87's avatar
LYeo87
Icon for Helper II rankHelper II
5 years ago
Solved

DATE 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 be...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @LYeo87 , Try a new column as

    New Date to [date1] + datediff([Date2],[date1],day)/2

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

@LYeo87 , Try a new column as

New Date to [date1] + datediff([Date2],[date1],day)/2

LYeo87's avatar
LYeo87
Icon for Helper II rankHelper II
5 years ago

Thank you! I'll give this a try!