On SQL as data source, Usersettings for date is not working
I copied app from Googlesheet to SQL server.
Original App has security filter to slice the row by date column.
It has been working on original app, but clone app working on SQL server is ruling out all the row by the same security filter.
I made sure that the column data type on table (SQL) is “Date” type. Could not find any reason for this failure.
Removing the security filter, showing all the row data from this table, so the security filter is obviously not correctly working on SQL.
Security filter is super simple#
USERSETTINGS(Date From)<=[Date of Visitation (From)]
Could someone in Appsheet have a look?