web

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

News and Announcements icon

Power Platform CommunityForums Power Apps problem changing date ...

Power Apps

Answered

problem changing date format

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a string type field that stores a date

whose value is as follows

Set(
 DateStart,
 DateTimeValue (DateStart.SelectedDate & "" & TimeStart.Selected.Value & ":" & MinStart.Selected.Value)
)

this works fine

The problem I have is that when I insert it
the format varies

sometimes it is inserted as follows

1/2/2020

and in other occasions this is inserted

January 1, 2020

I need it to always be stored with the numeric format (1/2/2020)

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Try this:

Set(DateStart,Text(DateTimeValue (DateStart.SelectedDate & " " & TimeStart.Selected.Value & ":" & MinStart.Selected.Value),DateTimeFormat.ShortDate))

Or replace ShortDate with ShortDateTime
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I've tried it and it works as I expected, thank you very much Eric I still don't know why this varied in format
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Yeah, that's an odd one.

Join the conversation