Solved: Un-representable Datetime Error (the added or subt... - Page 2

William_Robins · 01-21-2022 12:20 PM

Hi Everyone,

I just got started into AppSheets and would love some help. I searched the existing forums and help menu, but have only found one other post about this error I am getting. I tried their solution and it doesn’t really seem to be the same situation.

I am getting the following error:

"error:the added or subtracted value results in an un-representable datetime. parameter name: months/n"

I went through all my tables, found all the “date” fields and clicked into the expression writer for formula and initial value and then hit the test button for each of these. I was able to identify the table where the error is happening. I have a table called “Reports” which includes three fields; a key, a ref, and a date. Each row includes a date (i.e. 1/1/2019, 2/1/2019, 3/1/209…thru 12/1/2025) This date is used as a reference to aggregate the financial information in another table by date so that I can use it to build some financial dashboards. Originally this column was working fine as a “real” column, but recently I switched it to a “virtual” column and that is when my problems started.

The error appears when I try to “Add” a financial transaction to my other table. Any thoughts? I am worried this could be an AppSheet bug, but I wanted to check to make sure it wasn’t due to my own doing. Your wisdom would be greatly appreciated!

William_Robins

Hey, I finally figured out the issue after deleting each of my 70 virtual column expressions one at a time to see which expression was causing the issue.

I had an expression that was trying to find the earliest date in a column of type 'date' filtered by a customer ID. I was trying to find the date of the first order placed by each customer in a table with hundreds of orders with hundreds of customers by using a Min(Select table[date type column], where customerID = _this row (pseudo'ing here). Apparently, Min( ) doesn't work well with 'Date' Types and AppSheets isn't catching the error but rather is displaying the error directly from the server.

This definitely feels like an issue that would come up regularly enough that AppSheet could hopefully provide a stronger error prompt to help guide users to a resolution.

Thanks for everyones' help with this, hopefully it will help some future soul not go through the debugging pain I just felt!

View solution in original post

Un-representable Datetime Error (the added or subtracted value)