Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I convert the "Date Created" field to yyyymmdd format?

You can create a formula field of type text that has the following formula:

List("-",ToText(Year(ToDate([Date Created]))),Right("0" & ToText(Month(ToDate([Date Created]))),2),Right("0" & ToText(Day(ToDate([Date Created]))),2))

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit