Forum Discussion
Query "modified Date" error
So.... the issue was the date format and I had been trying to correct that error by setting the date local on that column. What I didn't realize in the beginning was that I had a second date column with the same issue. By setting both date columns to date locale at the same time enabled the query to remove the error.
Hi Gordon, Thank you for the feedback! Unfortunately the date field is used in several queries and a bridging query so i would have to basically rebuild the model to test your solution. I can't do that now because I am in the middle of a seminar.
So.... the issue was the date format and I had been trying to correct that error by setting the date local on that column. What I didn't realize in the beginning was that I had a second date column with the same issue. By setting both date columns to date locale at the same time enabled the query to remove the error.