You’re offline. This is a read only version of the page.
Hello everyone,
I'm very frustrated, because of trying something very simple, which won't work. I read countless threads and almost tried every single advice. Therefore I hope someone here could help me out.
My goal is to filter specific records of a SQL table. I want to get all records, where the value of a datetime column is between today and the next 14 days.
This is what I'd like to get to work.
But I always end up having issues like this one below.
I am very thankful for every advice!
Thanks in advance.
When you do your FormatDateTime() I would suggest leaving it in UTC time rather than converting it to the local timezone. If you are storing a Date/Time in a reqular SQL DataTime column its assuming that you are storing the UTC time. To store an actual local time you need to include a TimeZoneOffset datatype in SQL. So its complaining that you are trying to compare a UTC datetime with a timezone specific DateTime without including the timezoneoffset. So I would let you DAteTimeFormat process without specifying a format which will format the date as an ISO 8601 UTC date time. That is what the SQL server wants anyway.
Share
Report
All responses (
Answers (
68,678
