 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / October 2007Getting Invalid Date Errors with concatenate and substring functions
I'm using two text boxes to gather hours and minutes HR:MN They are set to 2 characters each. I have a date picker field that the user enters the date. I have a rule on the min field that says if the Plan_Depart_Date is present and the Min text field is present to set the value for the Plan_Depart_Time to: concat(substring(@Planned_Departing_Date, 6, 2), "-", (substring(@Planned_Departing_Date, 9, 2)), "-", (substring(@Planned_Departing_Date, 1, 4)), " ", @P_Depart_Time_Hr, ":", ., ":00") Planned_Departing_Date is a date field I'm getting 10-02-2007 23:14 but I'm getting not a valid date. What I want it to do is to concatenate the date, the hour and the minute (the hour and minute are military time) and set the value to the Plan_Depart_Time to 10-01-2007 11:14 PM as a valid date. Does anyone have the solution. I'm been working on this for 2 days. Thanks I believe you need a T between the date and Time. If you look at a Now(), which has both date and time without formatting you will see the correct format to emulate.  SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > I'm using two text boxes to gather hours and minutes HR:MN They are > set to 2 characters each. I have a date picker field that the user [quoted text clipped - 20 lines] > > Thanks Clay, You recommended Database Accelerator a short while ago. Please verify these points about Database Accelerator (DA): 1) I can design and upload InfoPath 07 templates to DA 2) Field technicians can complete those forms via their browsers? 3) WSS is not required at all for DA functionality, BUT does WSS enhance DA in any way? 4) Point 2 again!!!! Field technicians can complete those forms via their browsers? 5) I am looking at the Basic version because our customer has only one form, and DA makes more sense than $4400 for Forms Server. BUT! we don't want poor or scarce documentation and installation problems to raise the initial cost to $4400 +. Some of the commentaries about DA cite installation problems. Also, Microsoft and major vendors release patches all the time at no additional cost. It appears DA charges for patches. Am I correct? Thank you. > I believe you need a T between the date and Time. > [quoted text clipped - 25 lines] > > > > Thanks Correct (DBXL) can provide the solution and probably would not require WSS. A browser based form can use web services to recieve and submit. You can email me directly from the http://www.infopathdev.com site by clicking on my name in a post. Why don't you email me and we can discuss further. I can show you a demo if needed or we can verify what your solution would require. SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > Clay, > [quoted text clipped - 45 lines] > > > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.