Can someone tell me how I would translate this date string 20140901 into a date format like 09-01-2014.
Thanks
Hi TPLee and thanks for posting,
You will want to use two functions: subtring ang string-length. It's surprisingly easy. Let us know if you can't figure it out. Just email Support (at) Qdabra (dot) com.
Cheers,
P
Would you please tell a novice how the InfoPath 2013 control is formatted using substring ang string-length functions to facilitate a user filling out a form to be able to enter the date as 11182014 and have it displayed as 11/18/2014?