https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/88525.aspxSat, 30 Mar 2013 17:59:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88525Jimmy0https://www.infopathdev.com:443/forums/thread/88525.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=88525If you open the text box for the date in Form B, it should have some formatting options to allow you to display the date in a particular date format. You could also display it in a Calculated Value box, which has similar formatting options.https://www.infopathdev.com:443/forums/thread/88524.aspxSat, 30 Mar 2013 11:40:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:88524varam4u0https://www.infopathdev.com:443/forums/thread/88524.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=88524Hi All, I am getting problem with date format. I will explain the problem with one short example. Assume that there are two forms 1. Form A : Project (Date Type : Text ), Start Date ( Data Type : Date) ---> User enter the project name and start date and saves the details. 2. Form B: Project (Data Type : Text, But i changed the text box control to drop down box then showing all the projects of Form A using data connection, Start Date ( Date data type, but i have changed to text box. Because i need to make this box as read only.) When i select the project name in the Form B, i am allocating start date of that project (getting the info from Form A) to start date. But the problem here is , it is showing xml date format (2002-09-24-06:00) . For this i tried to used like concat(substring(StartDate, 6, 2), "/", substring(StartDate, 9, 2), "/", substring(StartDate, 1, 4)) .......but still getting validation error like "only date alllowed". How to resolve this problem. But i want the data type of Start date (in Form A & Form B) should be Date only. because i have few date difference calculation with other fields in the same form. I have attached those forms as zip file..... Regards, KV