How about wrapping part of the SQL statement that involves the "Dates" in an INT expression, so that only the date portion is used. As you are probably aware, both Excel and Access use Integers and Decimals for Dates and Times. The integer portion is the date and the decimal is the time portion of 24 hours.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
i tried INT(Lead.[Date Created]) but get a 3464 error, the same as if i used datevalue(Lead.[Date Created]).
i forgot to mention that when i use Lead.Date, everything works perfectly. if i use Lead.[Date Created] i get nothing but blanks.
Both Int(Lead.Date) and Lead.Date work perfectly.
Both DateValue(Lead.[Date Created]) and INT(Lead.[Date Created]) fail with runtime 3464
Lead.[Date Created] gives me blanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks