change date format

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Where is the data coming from?

Have you check at the presentation options of the datetime field in the forms?

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

I would research FORMAT() and you will need to CONCATENATE the field parts possibly. Something like FORMAT(YYYYMMDD, ColumnDate)

Good Hunting!

Denise McMillan SSCertifiable Points: 6216 More actions · Answer 3

I was able to get the results I needed by using

format(date_of_birth, "YYYYMMDDhhmmss")

Thanks for the help!