Formula to create automatic date without requesting it in the application form

[Emanuela]

How to automatically insert the current date without requesting it in the application form in seatable?

[fsa]

Hi,

please use the column “Created time”.

[Emanuela]

Thanks a lot!
would it be possible to insert the European format and remove the time?

[bennhatton]

Hi @Emanuela, you can eventually create a new formula type column to get the info in the right format. Assuming that the created time column is named created, you can use this formula :
day({created}) & "-" & month({created}) & "-" & year({created})
which will render the created date only (no time) in European format.

Bests,
Benjamin

[Emanuela]

@bennhatton thanks a lot!
but I hate having so many columns, however I will use it if I cannot find other solutions. But I wonder if I can customise the date format with just one column.