Select date ranges with LogParser

Here’s an addendum to my previous LogParser collection of scripts: how can we filter our IIS logs folder to extract only the events happened in a certain time range?

logparser "select * into 27.5.log from med*.log where to_timestamp(date,time) 
between timestamp('2008/05/27 10:11:00', 'yyyy/MM/dd hh:mm:ss') and timestamp('2008/05/27 10:13:00', 'yyyy/MM/dd hh:mm:ss')" 
-i:iisw3c -o:nat -rtp:-1

Note I’m using the to_timestamp conversion to combine date and time fields from the IIS log and compare to the date range I’m interested in.

Carlo