Click here to Skip to main content
15,884,298 members
Please Sign up or sign in to vote.
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.

1 solution

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.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900