what is the exact format for date_modified using API for Notes Module?

[allyforce]

When I use the API to figure out what the date fields format is for Notes, it just says 'datetime'.


What exactly is it expecting using datetime? I am using a standard .to_date method which outputs 08-08-10 for example, but I'm not clear what, exactly is it expecting.

Is there anybody who knows and has created Notes or perhaps someome from SugarCRM who can clarify (is there anyone going to supplement the API docs to make it more usable?)

[datasponge]

Hi Allyforce,

Sugar does a lot of operations on dates, so display dates are different than dates stored in the database.

In MySQL, dates will have a standard format of 'YYYY-MM-DD HH:MM:SS' so for example today's date of August 9, 2010 10:55 AM (and let's say 27 seconds) would go to and from the MySQL database as '2010-08-09 10:55:27' and it would be a string in the API (I'm not sure how it's actually saved, but that's an internal MySQL issue).

Sugar saves all dates as GMT time, so they are adjusted to GMT time on save and to Local time on retrieve.

You can control the dispaly format of local date and time in Admin panel on a per user basis.

Phil