Forum Discussion

chintusasmal123's avatar
2 years ago
Solved

Add Custom Column Error

I'm trying to create a custom column using 
DateTime.AddZone([Time],0) this formula , but getting error

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi chintusasmal123 

     

    DateTime.AddZone adds timezone information to the dateTime value. Is your [Time] column in datetime type? If not, it will cause an error. For example, if the [Time] column is Time type, it will have the following error. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Click in the cell beside the error please, and post it.

    Also, can you show us what the column looks like before the error step?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi chintusasmal123 

     

    DateTime.AddZone adds timezone information to the dateTime value. Is your [Time] column in datetime type? If not, it will cause an error. For example, if the [Time] column is Time type, it will have the following error. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!