Solved: Change Date and Time format - Page 2

AACarde · 02-19-2020 10:11 AM

I’m new and not great at programming but I do have some experience in spreadsheets.
I’m looking to create an ID from NOW() or similar. I was able to do it by CONCATENATE(“AS-”, NOW()) but I don’t like what it returns. IE… (( AS-02/19/2020 12:51:30 )). The date is kind of “on the nose” and I’d prefer something less obvious or, at least, without the forward slashes.
Maybe something like this (( AS-021920-125130 ))
If this exact format is not doable I’d be okay with something else. I just don’t like how it is now.
Is there a way to change the format of what date/time returns?

Suvrutt_Gurjar

Yes, your expression could look something like below

CONCATENATE(“AS”,"-",TEXT(NOW(),MMDDYYYY), “-”,TEXT(NOW(), HHMMSS))

View solution in original post