Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Text(Today(), DateTimeFormat.ShortDate) reports differently on mobile from desktop

(0) ShareShare
ReportReport
Posted on by 34

My app uses Text(Today(), DateTimeFormat.ShortDate) to send the text value of today's date to a SharePoint list. When I do this from a web browser on my desktop it reports today as 4/1/2020. When I use the iOS PowerApps app it reports today as April 1, 2020. I really don't care which it reports but why is it not consistent? That is really what I need here.

Categories:
  • JosWhite Profile Picture
    JosWhite 34 on at
    Re: Text(Today(), DateTimeFormat.ShortDate) reports differently on mobile from desktop

    This works. It feels a bit more like hard-coding the result, and shouldn't be necessary, but works. Thanks!

  • Verified answer
    MrNappa Profile Picture
    MrNappa 241 on at
    Re: Text(Today(), DateTimeFormat.ShortDate) reports differently on mobile from desktop

    In my experience, this behaviour may be caused by localization of your device/OS/browser. I'm not entirely certain how the end result is determined, though. Even if you specify an explicit language code, it may be overridden or fall back to default. 

     

    I think if you use a custom format that only uses numbers (like 'dd mmmm YYYY'), you can get a consistent behaviour.

     

    Be wary when using the text options though. For example, in some of my apps I use 'Text(date, "[$-nl-NL]dddd dd mmmm yyyy")' to display a date; but I observed that if my browser language is set to English, it doesn't display the date in Dutch. And if I view it on my device, and the device language is set to English, it also displays the English text.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard