I have a NOW() value in my app, which returns the correct values except for 12pm. For some reason it is returning 00:00 which could be confused with midnight. I have checked all the locale settings and they all correlate. The spreadsheet sees the correct value but appsheet then interprets it as 00:00. Is there a workaround for this?