Convert datetime to number or text

[cmartinez]

Hi,
I have been looking and I couldn´t find anything related.

I need to create uniques delivery numbers and I would like to get them from a Date Time column. E.g if I have a datetime value such as 17/09/2021 13:40:18 in column [Date] i´d like to convert to number 17092021134018 in column [Albaran]. Is this possible?.

Thank you.

[Suvrutt_Gurjar · Accepted solution]

Plese try TEXT() functions.

Something like
NUMBER(TEXT([Date] , “DDMMYYYYHHMMSS”) )

will give you the output in the desired format

help.appsheet.com

TEXT()

Format as text

[cmartinez]

Thank you!

text([Date],“DMYhms”)

[Sanjaykumar]

Thanks a lot. I was searching for this