(WSS2) Lists Web Service, add DateTime value

I want to use the Lists web service to add items to Events list.
However I dont know how to format the Datetime value

I use following Method xml for the updateListItems()

<Method ID='1' Cmd='New'>
<Field Name='ID'>New</Field>
<Field Name='Title'>New Event</Field>
<Field Name='EventDate'>2/2/2007 11:00 AM</Field>
<Field Name='EndDate'>2/5/2007 5:00 PM</Field>
</Method>

I got this error:
Invalid date/time value
A date/tme field contains invalid data. Please check the value and try again.

Jason



Answer this question

(WSS2) Lists Web Service, add DateTime value

  • Marlun

    try the UTC or GMT time formats.

  • CalinMac

    Dates have to be passed in the format YYYY-MM-DD or YYYY-MM-DDTHH:mm:ssZ. So for you case, try 2007-02-02T11:00:00Z for the EventDate and 2007-02-05T17:00:00Z for the EndDate.
    ---
    S.Y.M. Wong-A-Ton


  • (WSS2) Lists Web Service, add DateTime value