In my UI, the date is displaying 12/31/2020, but in the External Azure Database the date is 1/1/2021, so it is displaying database date minus one day?? Not sure why this is occurring or how to fix it?
The field is currently set as a date, but if I bring the value in as text, it works fine, but then I can’t use drop down filters to adjust the list based on dates. I’ve tried playing with the formatting with current or fixed time zone, but that doesn’t seem to affect it.
I’m thinking it has to do with either the External Database or the sql database connector query?