Click here to Skip to main content
14,636,672 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Wordpress References & Tutorials Pin
RickZeeland27-Oct-18 2:56
mveRickZeeland27-Oct-18 2:56 
GeneralRe: Wordpress References & Tutorials Pin
Roger Wright27-Oct-18 6:58
professionalRoger Wright27-Oct-18 6:58 
GeneralThe Useless bit of the week... Pin
glennPattonWork26-Oct-18 5:59
professionalglennPattonWork26-Oct-18 5:59 
GeneralRe: The Useless bit of the week... Pin
charlieg26-Oct-18 12:07
Membercharlieg26-Oct-18 12:07 
GeneralRe: The Useless bit of the week... Pin
RickZeeland27-Oct-18 3:05
mveRickZeeland27-Oct-18 3:05 
RantA matter of time Pin
kmoorevs26-Oct-18 5:01
Memberkmoorevs26-Oct-18 5:01 
GeneralRe: A matter of time Pin
PIEBALDconsult26-Oct-18 5:11
professionalPIEBALDconsult26-Oct-18 5:11 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 6:07
Memberkmoorevs26-Oct-18 6:07 
PIEBALDconsult wrote:
This is correct behavior.

Really, explain that to the customer that expects to see transactions that occurred at any time on the ending date they selected.

You are correct in terms of a SQL query, but not from a UI perspective. My habit when filtering on a single datetime field is to use BETWEEN and apply the max time to the ending date. This is why my import was correct. The problem is with the other vendors report and there's nothing I can do about it. Even advising them to simply extend the ending date by a day will not work because most records simply have all 0s as the time part. The ball is in their court. Smile | :)
"Go forth into the source" - Neal Morse

GeneralRe: A matter of time Pin
PIEBALDconsult26-Oct-18 6:30
professionalPIEBALDconsult26-Oct-18 6:30 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 6:36
Memberkmoorevs26-Oct-18 6:36 
GeneralRe: A matter of time Pin
Paul Horstink28-Oct-18 21:12
MemberPaul Horstink28-Oct-18 21:12 
GeneralRe: A matter of time Pin
dandy7226-Oct-18 6:54
Memberdandy7226-Oct-18 6:54 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 7:30
Memberkmoorevs26-Oct-18 7:30 
GeneralRe: A matter of time Pin
dandy7226-Oct-18 11:01
Memberdandy7226-Oct-18 11:01 
GeneralRe: A matter of time Pin
User 483504726-Oct-18 5:18
MemberUser 483504726-Oct-18 5:18 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 5:27
Memberkmoorevs26-Oct-18 5:27 
GeneralRe: A matter of time Pin
W Balboos, GHB26-Oct-18 5:31
mveW Balboos, GHB26-Oct-18 5:31 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 6:30
Memberkmoorevs26-Oct-18 6:30 
GeneralRe: A matter of time Pin
patbob26-Oct-18 6:10
Memberpatbob26-Oct-18 6:10 
GeneralRe: A matter of time Pin
kmoorevs26-Oct-18 8:03
Memberkmoorevs26-Oct-18 8:03 
GeneralRe: A matter of time Pin
patbob26-Oct-18 8:48
Memberpatbob26-Oct-18 8:48 
GeneralRe: A matter of time Pin
Sander Rossel26-Oct-18 11:08
professionalSander Rossel26-Oct-18 11:08 
GeneralRe: A matter of time Pin
Dan Neely26-Oct-18 11:17
MemberDan Neely26-Oct-18 11:17 
GeneralRe: A matter of time Pin
RandyBuchholz26-Oct-18 15:19
MemberRandyBuchholz26-Oct-18 15:19 
GeneralRe: A matter of time Pin
Greg Lovekamp29-Oct-18 3:25
professionalGreg Lovekamp29-Oct-18 3:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.