This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Date Formula Issue in AppSheet

Posted on 10-02-2023 06:55 PM
BernPrzO
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

I have a problem with the calculations in my app, where I use the expression

 

IF(DAY(TODAY()) > 27, EOMONTH(TODAY(), 1) + 1, DATE(YEAR(TODAY()), MONTH(TODAY()), 1))

 

I used it at 12:00 PM in the Central Mexico time zone, and it worked perfectly. However, when I used it at 7:00 PM, it started giving incorrect results. Instead of returning the first day of the current month, it gave me the first day of the next month. I have verified that the time zones for Google Sheets, AppSheet, and my phone are all set to Central Mexico time. Any recommendations on how to address this?

0 3 289
Topic Labels
0 Likes
Reply
3 REPLIES 3
Top Labels in this Space