• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Urgent help with Infopath date fields


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.

  • 2
1 Solution
Clay FoxDirector of Business IntegrationCommented:
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.

TechsavyAuthor Commented:
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.

TechsavyAuthor Commented:
I solved the problem myself

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now