Answered

Converting string to ShortDateTime

(0) Share

Report

Posted on by morall Microsoft Employee

This seems pretty straight forward and not sure what I'm doing wrong:

DateValue("7/22/2020 9:00 AM", DateTimeFormat.ShortDateTime)

Is returning an empty box. What am I doing wrong?

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@morall

You must use a 'language code' in the 2nd parameter. Not a date format.

DateValue("7/22/2020 9:00 AM", "en-US")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
morall Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
now I'm confused, how do I convert :

"7/22/2020 9:00 AM"

to a datetime object?

DateValue("7/22/2020 9:00 AM", "en-US")

evaluated to:

"7/22/2020" and stripped off the time

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@morall
I should have advised you to use the DATETIMEVALUE function instead.

DateTimeValue("7/22/2020 9:00 AM", "en-US")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@morall
Based on your Thumbs Up, did I solve your problem. Please Accept as Solution if yes!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No