Unanswered

DateTimeValue Conversion Issue

(0) Share

Report

Posted on by dyee4614

283

I am in the process of converting my application to sharepoint and i'm running into a weird (to me) error. I use a label that is just a now() function. This label is called Date100. When I patch the data to my sharepoint list, I use a patch function. Here are the two relevant lines.

Date: DateTimeValue(date100.Text,"ca-ES"),
DateValue: Value(Text(Today(),"[$-en-US]yyyymmdd")),

The correct value should be 11/12/2019. However, after the first entry it is reading it as 12/11/2019. The date value is reading it correctly 2019-11-12. What do I need to do to convert this to 11/12/2019? Note: The time is coming over correctly.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report
@dyee4614
Any reason you have chosen the language "ca-ES" in your first line instead of "en-US" as is shown in your second line? Changing the code...

Date: DateTimeValue(date100.Text,"ca-ES")

...to this instead appears to result in 11/12/2019. I've tested on my side.

Date: DateTimeValue(date100.Text,"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
v-monli-msft on at

Like (0)

Report
Hi @dyee4614 ,

What is the column type of "DateValue" column in your SharePoint list? Is it a date column or a number column? Are you trying to convert date to number? If so, please use below formula in the label control:

Value(Text(Now(),"[$-en-US]yyyymmdd"))

Regards,

Mona

Was this reply helpful? Yes No
dyee4614 283 on at

Like (0)

Report

Ha. That was it. For some reason, I thought ca-ES was English. This is embarrassing.

Was this reply helpful? Yes No