Qdabra qRules

Re: SubmitToSharePointList Appointment

Hilary Stoupa — Fri, 04 May 2012 16:03:28 GMT

Wonderful - thanks for your patience. It takes a little figuring sometimes to know what SharePoint expects - I think it is only Calendar lists that expect this format, I'm pretty sure we have tested date time data types with custom lists and not run into this issue.

Re: SubmitToSharePointList Appointment

camens — Fri, 04 May 2012 15:58:28 GMT

Working!!! Thank you very much.

Cam

Re: SubmitToSharePointList Appointment

Hilary Stoupa — Thu, 03 May 2012 23:42:31 GMT

I changed my /format parameter for my format date command - see attached. The rules are on Start Date and End Date - I'm using a custom format for /format.

Re: SubmitToSharePointList Appointment

camens — Thu, 03 May 2012 23:15:30 GMT

How did you manage to sneak the 'T' into the formula?

Re: SubmitToSharePointList Appointment

camens — Thu, 03 May 2012 23:10:25 GMT

OK, I'll try that right away.

Re: SubmitToSharePointList Appointment

Hilary Stoupa — Thu, 03 May 2012 23:08:08 GMT

There's a lot to be said for brute force. Try this for your format date:

/format=yyyy-MM-ddTHH:mm:ssZ

Works nicely for me....

Re: SubmitToSharePointList Appointment

Hilary Stoupa — Thu, 03 May 2012 23:05:05 GMT

But, if I add a "T" between the date and the time - they get created at the right time...

Re: SubmitToSharePointList Appointment

Hilary Stoupa — Thu, 03 May 2012 23:03:53 GMT

Oh, interesting! My multi day appts. get created at the right time, but the ones that start / end on the same day do not...

Re: SubmitToSharePointList Appointment

camens — Thu, 03 May 2012 21:37:47 GMT

Thank you for the example file, that helped alot. I am now getting the appointment created on the correct date, but the time is showing as 12:00:00 am regardless of what I use. Did that happen for you?

Re: SubmitToSharePointList Appointment

ErnestoM — Thu, 03 May 2012 20:28:24 GMT

Indeed, the SharePoint calendar does not like the date/time format. Hilary has come up with a nifty workaround: using FormatDate to set the dates to "u" format, meaning that now they'll have Z at the end. SharePoint seems to like this format. Here's the command:

concat("FormatDate /date=", <datefieldhere>, " /format=u")

I'm attaching a sample form which you can look at in design mode. Let us know if you run into any questions!

Re: SubmitToSharePointList Appointment

ErnestoM — Thu, 03 May 2012 17:46:32 GMT

We're investigating. More soon...

Re: SubmitToSharePointList Appointment

camens — Thu, 03 May 2012 17:44:14 GMT

Yes, my first thought as well. Don't know how to include a pic in this forum, but I did adjust the format to match the add event format and am getting the same error.

Re: SubmitToSharePointList Appointment

ErnestoM — Thu, 03 May 2012 17:35:16 GMT

I wonder if it might be a formatting issue. The SharePoint calendar list might want the date/time to look like this (and perhaps InfoPath is not matching exactly the format):

SubmitToSharePointList Appointment

camens — Thu, 03 May 2012 17:21:29 GMT

I am trying to create an appointment in the calendar using this command. I am getting an error that says "Errors occurred submitting to list: Invalid date/time value. A date/time field contains invalid data. Please check the value and try again.". I am simply using a date picker control with time. Can this be done or do I need to try and use a workflow?