RangerMSP Business Automation for successful ITs


Go Back   RangerMSP Forums > RangerMSP Software Discussion Forum (CCRM)
Search Today's Posts Mark Forums Read

Thread Tools Search this Thread
 
May 18th, 2020, 10:47 AM
CraigYellick
 
Posts: 53
I'm a SQL Server guy and don't query Advantage DB directly very often so am weak on syntax subtleties. Am trying to fetch all charges between two dates and no matter what variations I try it's always some kind of conversion failure or invalid operator for the type.

select * from slips
where SlipDate >= '05/09/2020 12:00:00 AM'
and SlipDate <= '05/15/2020 12:59:59 PM'

I've tried formatting the dates as 2020/05/09 and 2020-05-09, even tried doing a CONVERT to sql_timestamp. Nothing works.

One complicating factor is I'm doing this through a linked server query and quoted strings are a pain with the OPENQUERY() function so if the above is supposed to be working than that'll be important to know.

Thanks for any advice!

-- Craig
 
May 18th, 2020, 12:36 PM
Support Team
 
Posts: 7,510
Thank you for asking. Please give the following a try:

select * from slips
where SlipDate >= '05/09/2020 00:00'
and SlipDate <= '05/15/2020 23:59'
 
May 18th, 2020, 01:12 PM
CraigYellick
 
Posts: 53
Thanks for such a quick response. That's one variation I had not tried.
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search



All times are GMT -6. The time now is 04:17 PM.

Archive - Top    

RangerMSP - A PSA software designed for MSPs and IT Services Providers
Forum Software Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.