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.
:)
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!
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,