DateSerial

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I need to produce a query that will search a date range relative to a billing
date.

Basically this is for medical billing. I am trying to return whether a
procedure has been done within a 30 day period of itself.

If a procedure is performed on 10/15/08 I need to be able to filter the date
range to 10/14/08 and 30 days previous.

I am guessing the DateSerial function would be the best approach.

Can anybody help with the syntax or a better approach to this query

Thanks in advance

Stefan
 
I need to produce a query that will search a date range relative to a billing
date.

Basically this is for medical billing. I am trying to return whether a
procedure has been done within a 30 day period of itself.

If a procedure is performed on 10/15/08 I need to be able to filter the date
range to 10/14/08 and 30 days previous.

I am guessing the DateSerial function would be the best approach.

Can anybody help with the syntax or a better approach to this query

Thanks in advance

Stefan
Click to expand...

You wish to return records from within 30 days or the procedure date?

In your query, write, as criteria in the [ProcedureDate] column:

Between [ProcedureDate] and DateAdd("d",-30,[ProcedureDate])

or you can use:
Between [ProcedureDate] and [ProcedureDate] - 30
 
fredg said:
I need to produce a query that will search a date range relative to a billing
date.

Basically this is for medical billing. I am trying to return whether a
procedure has been done within a 30 day period of itself.

If a procedure is performed on 10/15/08 I need to be able to filter the date
range to 10/14/08 and 30 days previous.

I am guessing the DateSerial function would be the best approach.

Can anybody help with the syntax or a better approach to this query

Thanks in advance

Stefan
Click to expand...

You wish to return records from within 30 days or the procedure date?

In your query, write, as criteria in the [ProcedureDate] column:

Between [ProcedureDate] and DateAdd("d",-30,[ProcedureDate])

or you can use:
Between [ProcedureDate] and [ProcedureDate] - 30
Click to expand...

Would I use Between [ProcedureDate] - 1 and [ProcedureDate] -30
Since I do not want to include the date of the current procedure

Thanks
 
fredg said:
I need to produce a query that will search a date range relative to a billing
date.

Basically this is for medical billing. I am trying to return whether a
procedure has been done within a 30 day period of itself.

If a procedure is performed on 10/15/08 I need to be able to filter the date
range to 10/14/08 and 30 days previous.

I am guessing the DateSerial function would be the best approach.

Can anybody help with the syntax or a better approach to this query

Thanks in advance

Stefan
Click to expand...

You wish to return records from within 30 days or the procedure date?

In your query, write, as criteria in the [ProcedureDate] column:

Between [ProcedureDate] and DateAdd("d",-30,[ProcedureDate])

or you can use:
Between [ProcedureDate] and [ProcedureDate] - 30
Click to expand...

Would I use Between [ProcedureDate] - 1 and [ProcedureDate] -30
Since I do not want to include the date of the current procedure

Thanks
Click to expand...

Yes.
 
If you are doing this to identify over all records. I think you may want a
query that is something like the following.

SELECT A.PatientID, A.ProcedureCode, A.ProcedureDate, B.ProcedureDate
FROM Procedures as A INNER JOIN Procedures as B
ON A.PatientID = B.PatientID
AND A.ProcedureCode = B.ProcedureCode
WHERE B.ProcedureDate BETWEEN A.ProcedureDate-30 and A.ProcedureDate-1

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top