web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Timestamp generated by...
Power Apps
Unanswered

Timestamp generated by android device is not correct

(0) ShareShare
ReportReport
Posted on by 35

Good evening all,

     I've got an app where a record is being timestamped using the DateAdd(Now(),seteta,Minutes)    seteta is a variable being used to add 10, 20 or 30 minutes to the time.

     When a windows PC or IOS device uses the app, the timestamp is correct (using the same user) but when an android device is used the times stamp is out by +1 hr.  timezone is  of users is Sydney, Australia.  The timezone will always be the same.  Is there a way to force timezone?

Categories:
  • AlanCampbell Profile Picture
    35 on at

    I've just looked at the raw data in my SQL table where the data is stored, the time being saved is out by an hour. the time on the android device is correct, I'm wodering if daylight savings if daylight savings isn't being applied correctly, but why only on android with teh powerapps, anythoughts on how to debug this?

  • bdodu Profile Picture
    399 on at

    Most probable you have in the database the UTC datetime and in the app the localdatetime.

    There is the TimeZoneOffset function which you should use, please find here the usage.

     

    As best practice I used in my apps was to keep the datetime in database as UTC and convert it within the app with the proper TimeZone.

  • AlanCampbell Profile Picture
    35 on at

    Hi bdodu, the android device is the only device that is storing the incorrect UTC time in the database, IOS and windows devices using hte app are all storing correct times in UTC, I am using the 

     

    now()

     

    command,  IOS and windows both save the same time to the sql database (in UTC) the android device is out by +1 hour

     

    it's very odd, as I can't figure out how to tell which type of device is using the app, I can't adjust the time when it is saved.  

     

    any thoughts?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard