Skip to Content
0

Can I do this in a record select?

Dec 13, 2017 at 05:09 PM

27

avatar image
Former Member

I want to select dates that go back to 60 days (51-60). this is not compiling:

datediff(d,Voucher_Service_date,getdate()) between 51 and 60 and {vwGenVouchInfo.Billing_Carrier_ID} <> 0

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Brian Dong Dec 13, 2017 at 06:38 PM
0

Hi Paul,

This should work for you:

DateDiff ("d", {table.Voucher_Service_date}, Today) In [51 to 60] 
And {vwGenVouchInfo.Billing_Carrier_ID} <> 0; 

Thanks,

Brian

Share
10 |10000 characters needed characters left characters exceeded