Getting Invalid Date Errors with concatenate and substring functions

[sboyd]

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

 

[Clay Fox]

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.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Iakov]

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.

 

[Clay Fox]

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.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com