Type in a date on 1 table and it populates also in another table

There are two ways to go about it.

The first way is to use a Trigger after update on the Date field that copies the data to another date field in another record. This method is useful if you need the ability to change the date on one record without it affecting the other.

The second way is to either use a relationship between the records or create one. If you already have a relationship field and you want the data of a field from the parent record then you can do something like:

relationshipfieldname.Datefieldname

If you don’t have any relationship field then you can do something like:

let t := this;
let getOtherRecord := first(select Table1name where fieldname = t.fieldname)
getOtherRecord.Datefield

Line 1, creates a variable called “t” and stores the current record data

Line 2, creates a variable, “getOtherRecord” and then goes out and finds the first record that matches the filtering from another Table.

Line 3, since there is only 1 record returned from Line 2, we can then reference the Datefield and it will show up.

Since this is a formula field you can not change the date.