Urgent help with Infopath date fields

Posted on 2011-05-12
Last Modified: 2012-05-11

I am importing a date field into infopath form from SP list and I get a data validation error. I am using SP list as secondary data source.

How can I prevent this issue?

Please help.

Question by:Techsavy
    LVL 28

    Expert Comment

    You need to put all of your fields of the form on a view.

    That way you can see which field is red and having the issue.

    Then it is a matter of addressing whatever the specific validation is.

    Convert a field value or make sure it has one etc.


    Accepted Solution

    Hi Calyfox,

    Thank you for the quick reply. I solved the problem. What was happening is : when we import a Datetime field from Sharepoint into infopath it imports it as a SQL date format. so I had to use translate(@importedSharePointColumn, " ", "T"), to make it compatible with InfoPath.


    Author Closing Comment

    I solved the problem myself

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now