cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

Anyone else noticed an issue when using DateValue() or DateTimeValue() on iOS?

 

It works in the browser but doesnt display anything on iOS.

 

Works as expected without datevalue or datetimevalue but I don't like the formatting.

 

My code is :

Concatenate(Text(DateTimeValue(OutboundDateTime),"dddd mmm yyy - ")," ",Text(DateTimeValue(OutboundTime),"hh:mm AM/PM"))

 

but it doesn't display... Any ideas / work-arounds?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

I managed to get it working with the following

 

Concatenate(Text(DateValue(DataCard12.Default,"en"),"ddd dd mmm yyyy")," - ",Text(TimeValue(OutBoundTimeCard.Default,"en"),"hh:mm AM/PM"))

 

Not too sure what the issue was though but thanks for getting back to me

View solution in original post

5 REPLIES 5
Highlighted
Power Apps
Power Apps

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

What is the value of `OutboundDateTime`? Is it a text value, a date value, something else?

 

I tried the following formula, and it worked fine both on Windows and iOS:

Concatenate(
    Text(DateTimeValue("2016-07-08T17:15:00"), "dddd dd mmm yyy -"),
    " ",
    Text(DateTimeValue("2016-07-08T17:15:00"), "hh:mm AM/PM"))

And it displayed "Friday 08 Jul 2016 - 05:15 PM" as expected.

Highlighted
Anonymous
Not applicable

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

I managed to get it working with the following

 

Concatenate(Text(DateValue(DataCard12.Default,"en"),"ddd dd mmm yyyy")," - ",Text(TimeValue(OutBoundTimeCard.Default,"en"),"hh:mm AM/PM"))

 

Not too sure what the issue was though but thanks for getting back to me

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

Whats happening here MS, this was first reported in 2016!

DateTimeValue doesnt work on ios and flows fail to run because of it.

It works fine on desktop.

 

Few examples

Sending Date to Flow for SQL:

Text(DatePicker1.SelectedDate,"[$-en-GB]yyy-mm-dd") & " " & Left(0730,2) & ":" & Right(0830,2) & ":00.000"

This works fine on desktop but not ios.

 

DateTimeValue:

DateTimeValue(Text(DatePicker1.SelectedDate,"[$-en-GB]yyy-mm-dd") & " " & Left(0730,2) & ":" & Right(0830,2) & ":00.000")

This displays fine on desktop but does not work on ios at all.

 

 

Highlighted
Power Apps
Power Apps

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

You're correct, DateTimeValue fails in iOS - but only if you have millisecond precision. I've opened a bug to the appropriate team to have it fixed.

 

If you use the expression below (notice the absense of the milliseconds) it should work on both iOS and Windows.

DateTimeValue(
    Text(DatePicker1.SelectedDate, "[$-en-GB]yyy-mm-dd")
    & " " & Left("0730",2) & ":" & Right("0830",2) & ":00")
Highlighted
Impactful Individual
Impactful Individual

Re: Dates & Times not displaying on iOS when using DateValue() or DateTimeValue()

aah, its nice to know its milliseconds that cause it, although im sure i tried without...

It has to be in a specific format from iOS aswell, you have to format as dd/mm/yyy hh:mm for it to accept, trial and error took me ages as from desktop i was using yyy-mm-dd hh:mm and it worked fine

Thanks 

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,156)