Skip to content
+1-888-319-3663

COMMUNITY FORUM

Convert field to gp date

Dan Bigelow asked 3 years ago
All,
I have a field which is setup as Double.  it has a date and timestamp for example 20190214063005.  I need it to be a date format:
02/14/2019 – what is the best way to do this?
Answers
Patrick Roth Staff answered 3 years ago
Dan,
Well if this is a “datetime” field – then it shouldn’t be set up as a double.  It should be a string/char field.
But I think you’d be ok since you wouldn’t have leading zeroes since that is the year.
The easiest route is to use a Date Calculation:
https://www.eonesolutions.com/discussion/changing-format-of-document-date/
as your date format appears to be
yyyyMMddhhmmss
that should be the source format, then just need one for the destination format – MM/dd/yyyy

If you would like to submit an answer or comment, please sign in to the eOne portal.