Excel query help

[Rick]

I’ve got a basic Excel macro which runs a select query on a Datasource and dumps the result into the worksheet. One of the fields it picks up is a date field. Does anyone know how I can amend the code so that it will only bring back entries where the date field entry is from the last 30 days?

I’ve had a look round on the net for help without much success.

Cheers in advance

Ric

 

[DamoWales]

Is there not a range thing on there at all when you can select say

Date - 31 Days?

Havn't used Excel in ages, hope this helps at all?!

 

[sh33n]

Why not just pull across all the data and then filter out anything older than 30 days?

Would be easier.

 

[Black-Clio-1.4]

For intCounter = 2 To 9999
strCell = "AB" & intCounter
If Date + 31 = Range(strCell) Then
strRange = "A" & intCounter & ":AB" & intCounter
Range(strRange).Select
Selection.Copy