Hi, I have a drop down menu that is receiving a date from a Sharepoint configured date field set to "Date Only". The drop down menu has the correct date (Year-Month-Day format) but also has 00:00:00 at the end. This is obviously the default time. How can I remove this from within the Infopath drop down menu? I assume I could use some type of function? Also, it would be nice to be able change the format of the how the date is displayed within the drop-down menu.
Thanks!
You can try to change the date within SharePoint.
Or you can use a setfield command on the dropdown to set it to substring-before(date, " ")
That should remove the time characters.
Wow, thanks Clay. You certainly pointed me in the right direction. Here is the actual string i used (turned out to be really easy):
(substring(., 1, 10))
here is a blog that helped a lot:
http://blogs.interknowlogy.com/jeffschroeder/archive/2007/02/08/11343.aspx
Here is a blog entry I created for the solution to this:
http://bladah.com/?p=34