Here is the situation. I have a formula field coming from Airtable that represents an expiration date. I have an action button which creates a new record (a renewal of the previous) and uses the expiration date from the original record for the “as of date” on the new record. So, original expires today (March 19, 2025), new record would begin same day.
If I set the action as a modal form and use this to set a default date that can be confirmed by the user it will show the date I want (19th), user confirms and record is created fine. If I try to make it quicker for the user by using a hidden field set up the same way it will create the record with the incorrect date (18th). Both cases are set up the same way and it seems like it should be consistent.
I realize that time zones could be a factor, but even so, shouldn’t the behavior be the same?