mjf-acqyrexchange

A url that contains a query parameter that is not defined in the API is not flagged as an error. This can be dangerous if a request has a misspelled,...

I have a cell with the following formula ``` =DATEVALUE(LEFT(D2,10))+TIMEVALUE(MID(D2,12,8)) ``` D2 contains `2022-04-21T00:58:37.875Z` The viewer renders it with the `#NAME?` error. These work in Excel. Another cell contains `=NOW()-F2`...