Method Community

 

Date not properly stored in method.me table

Last post 12-19-2017 8:06 AM by whitebuck. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-18-2017 5:16 PM

    Date not properly stored in method.me table

    Hello,

    I am new to Method.me and I have been playing with saving data from a website to the method.me crm.

    Today I stored a date as 

    2017-12-18 00:00:00
    
    
    What shows in the form page is:
    Dec-17-2017 06:00 PM

    Can anyone tell me what I might be doing wrong?
    Thanks,
    Mike.

  • 12-18-2017 8:13 PM In reply to

    Re: Date not properly stored in method.me table

    Hi whitebuck. Welcome to Method!

    Dates are stored in Method in UTC time (https://en.wikipedia.org/wiki/Coordinated_Universal_Time).

    The UI converts the UTC time to your local time when displaying, and converts local time to UTC when saving.  That way the time is accurate to the viewer regardless of where they are around the world.

    So, when using the API you'll have to convert your local time to UTC time before saving.

    Hope that helps,


    Paul

  • 12-19-2017 8:06 AM In reply to

    Re: Date not properly stored in method.me table

    Ok, that seems to work, I will continue to mess with it.

    Thanks,

    Mike

Page 1 of 1 (3 items)