Skip to content


Convert field to gp date

Dan Bigelow asked 4 years ago
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?
Patrick Roth Staff answered 4 years ago
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:
as your date format appears to be
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.