Date Time field format


#1

I am at war with date & time field :rage:

1 - Events table with date & time field eg "Event Start"
2 - Staff table with lookup field to Event -> Event Start , formatted to date time with local / 24h / same time zone

Challenge:
-> transform lookupfield into date&time field (change field type: lookup to date&time)


#2

as allways, enlightenment came to late :joy: :innocent:

its about the transforming and recognizing the format

whenn set to “local” (1.5.2017) every format will be changed to 5.1.2017

so dates like 13.12.2017 must first be changed to “europe” and then to “local” otherwise will not be recognized

i think this should be done automaticaly by @Air_Table