Last two weeks code 2

[gennaroalpha7]

Hello -

I have a report that I would like to generate for the last two weeks of (tickets) data. Here is the code that I have so far...

Date ({CallLog.RecvdDate})>= Lastfullmonth and
not ({CallLog.CallType} in ["ATM Night Bag", "ATM Debit Card", "ATM", "Dispenser", "Password-Laptop", "Password-Lan.", "Password-Lan", "Password-App", "Password.....", "Password....", "Password.", "Password -FC8", "Password"])

Would it be appropriate to use this new code to generate the last two weeks of data?

DateAdd("d",-14,CurrentDate)

instead of:

Date ({CallLog.RecvdDate})>= Lastfullmonth

And, when I plug in the new code it says 'A boolean is required here'. My new code is like this:

DateAdd("d",-14,CurrentDate) and
not ({CallLog.CallType} in ["ATM Night Bag", "ATM Debit Card", "ATM", "Dispenser", "Password-Laptop", "Password-Lan.", "Password-Lan", "Password-App", "Password.....", "Password....", "Password.", "Password -FC8", "Password"])

I am learning, slowly but surely. Thanks for your help.

Alphaseven

 

[fisheromacse]

i am probably not giving this the necessary amount of thought, but just off the top of my head, try the below instead of "DateAdd("d",-14,CurrentDate)"

(Date ({CallLog.RecvdDate}) in [DateAdd("d",-14,CurrentDate) to currentdate])

 

[pmax9999]

I would do I this way:

Date({CallLog.RecvdDate}) >= (CurrentDate - 14) and
not ({CallLog.CallType} in ["ATM Night Bag", "ATM Debit Card", "ATM", "Dispenser", "Password-Laptop", "Password-Lan.", "Password-Lan", "Password-App", "Password.....", "Password....", "Password.", "Password -FC8", "Password"])

Cheers
Pete

 

[gennaroalpha7]

Thank you pmax9999 and fisheromacse. Have a good one.

Alphaseven