web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Incorrect date conversion

Power Apps

Answered

Incorrect date conversion

(0) Share

Report

Report

Posted on by Mo_Islam

149

Hi,

I have a SP List in which the date and time are stored as text string:

dd/mm/yyyy hh:mm

I am using AddColumn in a collect statement to convert this text string to DateTimeValue

ClearCollect(colB,Sort(AddColumns(MA_Timetable_2,"START",DateTimeValue(EventStart),"END",DateTimeValue(EventEnd)),ID,Ascending))

The problem is the date is being converted incorrectly.

Any help or guidance would be much appreciated.

What am I doing wrong?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Mo_Islam ,
You are using a "dd/mm/yyyy" system to collect your data as text in SharePoint and DateTimeValue recognized datetime type implicit in "mm/dd/yyyy". That why the conversion gives a datetime value where your day is recognized as month (because is greater that 12 it add a year and give you the remaining month), and your month is recognized as day.

In other words to solve your problem, you have to set language_code parameter of function DateTimeValue to one similar to your data format saved in Sharepoint (i think "fr").

Your new formula is:
ClearCollect(colB,Sort(AddColumns(MA_Timetable_2,"START",DateTimeValue(EventStart,"fr"),"END",DateTimeValue(EventEnd,"fr")),ID,Ascending))
and should working fine.

Hope it helps !

Was this reply helpful? Yes No

Join the conversation