InfoPath Dev

been struggling with this one.....  i am trying to get a date field in my form to format to dd/mmm/yyyy.    the closes i can get is dd-mmm-yy .   my problem is that even when i select that, it is like infopath ignores it and wants to put it in the format infopath wants......   is there a substring formula i can use to fix this?   this is driving me crazy......

 

 

Do you want it to appear like that in InfoPath or in SharePoint?  If its InfoPath, you'll have to use substrings to get the specific format you want if its not one of the out of box formats in the format date properties dialog.  If its SharePoint, you could try and use a calculated column but to be honest not sure if that will 100% work for you.  Just keep in mind that if you set it one way in InfoPath it doesn't mean that it will be reflected the same way in SharePoint.  You are simply changing how its displayed in the control via InfoPath.  The field data itself isn't being changed, so that means it won't get reflected in SharePoint.  Hope this helps,