Date to Single Line of Text Error

(1) Share

Report

Posted on by CU17012318-0

I keep getting this error the string was not recognized as a valid datetime. there is a unknown word starting at index 1.

I am trying to patch a date input and 3 drop downs for hour, minutes and AM/PM to a single line of text. I created a collection to store the data, but it keeps saying the same error.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@CU17012318-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU17012318-0,
Firstly, can you please remember to post your code in Text - saves re-typing here. The code below is OCR'd so watch spelling.

If you are using something similar to this blog of mine, and are trying to convert it into a valid date/time to update a field of that type, the first one is
'Departure Date': dp_Departure.SelectedDate + Time( If( dd_DeparturePM.Selected.Value = "PM", 12, 0 ) + Mod(Value(dd_DepartureHour.Selected.Value), 12), Value(dd_DepartureMin.Selected.Value), 0 )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No