Hi there, any ideas on why I am having a problem with a date column?

M.Lambert
M.Lambert Contributor
in General

When I load the data is showing the date sign on the column but when I ask which datatype it says is alphanumeric and is no letting me change to date.

image.png
image.png
image.png

Best Answer

  • Henry Simms
    Henry Simms Administrator
    edited May 10 Answer ✓

    Unfortunately the format you have isn't one of Data Studio's supported date/time formats, so it is not automatically converted. The "in" value with millisecond is parsed, but not the values with microseconds / nanoseconds:

    image.png

    You may need to use a Transform to remove microseconds before parsing to a date.

    Unlike a standard database, a column in Data Studio can contain values with different types (eg Date and Alphanumeric). I think the icon next to your DropAt column indicates that you've selected "Automatically detect the type of data for each column" on load, and that most of the value have been parsed as dates (i.e. it's the dominant data type)

Answers

  • M.Lambert
    M.Lambert Contributor

    That worked Henry,

    Thanks a lot for your help!

Categories