Solved: Error with "Start" Expression - Page 2

Matias_Sanchez · 02-22-2021 11:26 AM

Hello, Im writing because Im trying to create a reporting app, when generating the template in xlsx format, I use the “Start” expression to bring data such as date and time and the application brings me erroneous data that are not even in my database, showing incorrectly the data “Date” and “Time”. The date in the database is 02/02/2021 and the Start expression brings me the following data “44231”. The same happens with the time, in this case it would be 9 AM and the start expression brings me the following incorrect data “0.4826388889”. I have already adjusted the cells to accept only Date and Time values, but the error still occurs and I can not continue advancing with the app.

Steve

Make sure that the Fecha column in the app is of type Date, and that the Hora column in the app is of type Time.

In the spreadsheet, make sure the Fecha column is formatted as a date or as plain text, and that the Hora column is formatted as time or as plain text. Do not use the Automatic format for the spreadsheet columns.

View solution in original post