Sharepoint & Infopath date query

Question

0.00/5 (No votes)

See more:

Hi I am wrting a Training booking system(following the steps in the book Sharepoint 2010 creating and implementing real world projects).
All is ok apart from one thing. The systrem has a SP list that has start & end columns that are date/time columns. If i enter a new course directly into the list, then it shows the start date in the format as expected. The Form that i am then trying to create uses this field via a data connection so that i can filter the courses using a rule for example 'start < now()' to show/hide course that are from the past.
No mater what i try i cannot get this to work. As a further test i have also added a calculated field control to the form, this control looking at the field in the sharepoint list, but the output of that comes back in the wrong format. I m guessing that this is the reason why my filter doesnt work, but i cant work out why.

Any ideas are really appreciated as this is driving me mad.

Posted 19-Apr-13 10:51am

skybluebazza

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rupesh Tarwade · Accepted Answer · 2013-05-18T08:38:00

InfoPath form uses xml to store data and understands date in "yyyy-MM-dd" format only. The date control properties have format button which can be used to display the date in a specific format. Now if you are sing a date from InfoPath form in a DataSource you will have to re-format it. Try writing your filters in "yyyy-MM-dd" format and check if your logic works.