Can you please help me in creating a timestamp?

Technical Help
1

Hi,

I am deepa from Bprovidence Intl PBC. Can you show me the way to create a timestamp column that includes date, hour, minutes, second and milli second. Any help will be greatly appreciated. Thanks, Deepa.

2

Hi,

You can add a formula field with the following formula:

date_diff('ss', todate('1970-01-01', 'YYYY-MM-DD'), field('Date'))

Replace the field(‘Date’) with the column where you have the date that needs to be converted. This can for example be a field that holds the Created on date

image

Regards
Frederik

3

Hi,

Will try and let ou know.

Thanks, Deepa