Newbie question, date

[Denis_Filion]

I am sure it is quite simple, but for some reason, I can't find the way to do it.

Let us say I have Table A. In the Table A, I have, amongst many others, a Date field.

I also have Table B, with two fields in it. One field is a (unique) Date. The other field is just a number. Let us call it [Day Number].

[Table A/Date] and [Table B/Date] are not linked.

I just want [Table A] to look at its own [Date] field, then search for the corresponding [Date] in [Table B] and retrieve the corresponding [Day Number].

Must not be very difficult, but I can't find the way!

[ScottWorld]

No, that is not possible in Airtable unless you link the records, or write an automation to do it for you. You can write an automation by using Airtable's native automations or by using Make.

[Sho]

Here is an example of using automation.
Airtable - Date Matching
Copy this base and add the following automation

In automation, Dynamic values cannot be used for date types, so they need to be formatted into a date string for comparison.

Be careful, the Free plan allows only 100 automation runs.

[Denis_Filion]

Great, I'll try that for sure, looks exactly what I need.