Skip to Content
avatar image
Former Member

Can I do this in a record select?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 13, 2017 at 06:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded