Wrong date showing when using AddColumn

(0) Share

Report

Posted on by Mo_Islam

149

Hi,

I have a table which stores:

eventdate = DATE ONLY

timestart = TEXT (e.g. 10:15)

timeend = TEXT

When I pull the data and merge them thru adding a column, I go from (a) to (c), instead of going to (b)

(a)

From dataverse table

(b)

RESULT I WANT

(c)

What I get

craf7_eventdate [10/31/2020]

craf7_timestart [14:00]

10/31/2020 14:00

7/10/2022 2:00 PM

The code is here:

ClearCollect(
 colAddEvent,
 AddColumns(
 ShowColumns(
 Filter(
 Database1,
 StaffName = ddStaffSelector.Selected.craf7_staffname
 ),
 "craf7_eventdate",
 "craf7_timestart",
 ),
 "START",
 DateTimeValue(
 craf7_eventdate & " " & craf7_timestart,
 "en-GB"
 )
 )
)

Is there something I am doing wrong?

Thank you

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Mo_Islam

Please consider changing this part of your Formula to the following:

"START", craf7_eventdate + TimeValue(craf7_timestart)

Your Date is already a date type, so trying to use it in the DateTimeValue function will cause it to convert it to a string. This will most likely convert it to 31/10/2020 - which is 7/10/2022

So, in the above formula, just add the time value as converted from your text to the eventdate which is already a date.

I hope this is helpful for you.