Forum Discussion

shinney's avatar
shinney
Helper I
5 years ago
Solved

Grabbing data with API, unable to convert datetime column to a date

Hello, I'm trying to build a timeline chart based on count of tickets vs. date. We are recording the dates of when our report tickets come in on a datetime basis.  First step would be to convert ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi shinney 

    You can add a custom column to contain only date values from the original datetime column. Just like below.

    = Date.From([Old DateTime column])

    This date column is able to be changed into Date type. You can remove the old datetime column and use this new date column later.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi shinney 

You can add a custom column to contain only date values from the original datetime column. Just like below.

= Date.From([Old DateTime column])

This date column is able to be changed into Date type. You can remove the old datetime column and use this new date column later.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.