Report of Pre-d's

[Anthony J Turner]

We have been enetering pre determinations received as they come in but they drop off the aged ins list. Could someone give me the script for a sql query for pulling up the list?

[drtech]

select DateReceived, PatNum, ClaimStatus, DateSent, ClaimFee from claim
where claimtype="PreAuth" AND DateReceived>'2007-05-01' OR Claimtype="PreAuth" AND DateReceived<='0001-01-01'
Order By DateReceived DESC



and you can change the date up there that says 2007-05-01 to include however many you want.

[jordansparks]

Wouldn't you have to put in some parentheses?

select DateReceived, PatNum, ClaimStatus, DateSent, ClaimFee from claim
where (claimtype="PreAuth" AND DateReceived>'2007-05-01')
OR (Claimtype="PreAuth" AND DateReceived<='0001-01-01')
Order By DateReceived

[drtech]

for clarity, yes, but I think mySQL treats everything on either side of the OR like it has parentheses...b/c I get the same result.

[Anthony J Turner]

Thanks

[Anthony J Turner]

Thanks