Data table: find data in row according to date

Hello and thank you for your answer.

I am not sure it responds to my confusion :confused:

I indeed have a format problem that I have to correct from the spreadsheet - btw the integers in the first column are due to an import bug when I save the spreadsheet as a CVS from open office, without this extra column the CVS wouldn’t import properly in UE.

But I do not understand how (the first part of your answer) allows to automatically find the date of the day (today) and output the temperature data that corresponds to its row?

What I want to do is really this:

If (‘Date_1938_from_data_table’ = ‘today_date’) {
then output corresponding row for ‘Temp_Hamamatsu’
}

For exemple :

if (‘1 mar (1938)’ = ‘1 mar (20XX)’) {
then output 8.5
}

The idea is to have a system that updates automatically everyday.
Everyday, the corresponding date is found and the associated temperature is outputed.

(Then, I do the substraction between the 1938_temperature and today_temperature. But I figured this operation already.)

What I don’t get, is how to get the data I want from the data table everyday?

That is why in my screenshot I used the function ‘Now’ and ‘As date’ to output a string for today.
Then, the idea is to find the corresponding string within the table data and output the corresponding temperature.
So I understand that the date format from my CVS and Unreal date format have to be the same.
I just don’t know if that is the right way to do and also how to do it properly.
A far as I understand your answer doesn’t take in account this everyday-update aspect? or am I missing (likely) something?