InfoPath Dev

Hi All

Hope you can help

I have produced a form in infopath 2010 which utilises an Access Database as a datasource. The field in the table is set as GeneralDate and the field in infopath is a Datetime Picker. My problem arises when you enter a date and then change the time in Infopath Form Filler the date is reset to the current date.

 Any help very much appreciated.

And there aren't any rules on the time field? I'll see if I can reproduce this....

.

Hilary Stoupa:

And there aren't any rules on the time field? I'll see if I can reproduce this....

Hi 

No rules or filters are applied

Thanks trial and error found the answer thanks

Answer:

Ensure that Access database field has no format.

Select Date Dicker >> Datapicker Properties >> on the DataTab click Format located next to the Data Type field and amend to your regional settings..