Automation for updating date

[FPX]

Hi all

I have an Orders Table and an Order Line Items table.

I have a Date Required field within the Orders Table which is linked to my Order Line Items table.

I want to have an Updated ETD (estimated time of departure) field against each line item so it is separate from affecting the overall order ETD (i.e. each line item with one order can have a different ETD).

Ideally I want to just show the format as mmm-yy (i.e. July-24)

Any ideas on automating this so that the Updated ETD takes the Date Required data but can be editable?

Thanks!

[dilipborad]

Hello @FPX ,
The formula field is not editable. but you can use formatting option while creating that formula.
For example

DATETIME_FORMAT({your_field}, "MMM-YY")

[FPX · Accepted solution]

Thanks. Doesnt need to be a formula.

I am just trying to create an automation that will pull the date from master orders table but allow overriding for each line items updated ETD (if required)