This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have tried using the [Date] = DateTimeAdd(DateTimeToday(),-1,"DAYS") with no luck at this point. Everything I have found here says this should bloody well work but it continues to vex me. If anyone can help it would be greatly appreciated.
Solved! Go to Solution.
I think the issue is because `DateTimeToday()` gives you date AND time. So you get: '2018-09-13 00:00:00', and since your existing date columns do not have the time, there are no matches.
By changing your filter to:
[Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"day"), '%Y-%m-%d')
I was able to get some records output.
Let me know if this is what you were looking for,
Cheers!
@tcroberts has again provided an excellent solution.
The only possible improvement I would make is to reduce the amount of typing you have to do
[Date] = DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"day"), '%Y-%m-%d')
becomes
[Date] = ToDate(DateTimeAdd(DateTimeToday(),-1,"day"))
ToDate truncates the DateTime value returned by DateTimeAdd to a Date by removing the time information
Dan
it solved my purpose really cool.