InfoPath 2010

Re: Date/time dropdow format.

Toral Patel — Mon, 12 Dec 2011 18:45:04 GMT

Hey, thank you for replying and sorry to reply u little late, was away from this issues for a while.

I will definetely check the way you suggested.

Thank you,

Re: Date/time dropdow format.

ErnestoM — Wed, 07 Dec 2011 14:10:18 GMT

Hi-

It sounds like perhaps the form schema is locked to the SQL data type. If the SQL data type is datetime, then the Infopath control is also going to be locked to that data type. Try displaying this as an Expression box instead of a dropdown to see if you can modify the way it is displayed. Good luck!

Date/time dropdow format.

Toral Patel — Tue, 06 Dec 2011 22:23:33 GMT

Hello,

I have created one form connected to access database. I have one dropdown box on form which displays set of dates stored in db. The field is of date/time type. It displays in the dropdown box with date and time. It is now allowing me to change format from the dropdown properties. I just required to display date in mm/dd/yyyy format.

Any help with this?

Thank you in advance.