Concatenate date parts and times... getting invalid date errors.

S

sboyd

I have 1 field - Plan_Depart_Date that is a date picker field
formatted with no time,
1 field that is a 2 character text field that is for the user to input
an Hr (in military time)
1 field that is a 2 character text field that is for the user to input
a Mn (in miliaray time)

I have a rule set on the Minute field if that a date is present in the
Plan_Depart_Date and a Min is present to set the value on a 4th
Plan_Depart_Time (Date time) field 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")

Its coming out like this
10-2-2007 24:13:00 and is giving an invalid date message. I need it
to come out as a valid date/Time and looking like this
10-2-2007 11:13 PM.

I've tried a number of variations to get this and I have had no luck.
Does anyone know the secret answer?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Invalid Date Errors with concatenate and substring functions 3
Date and Time Picker 6.0 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Template with fields and premade texts.. 0
separating date and time 5
Page numbering with Merged Document and IF statements 1
Work Budget Salary vs Real Time Salary 0

Top