How to set date as a parameter when using Log Parser
07:43 18 Jun 2015

When using Log Parser, it actually support pass parameter to a sql file. In my case, I want set the output file name to contain today's date in format of yyyyMMdd. Here's my sql file content:

SELECT RecordNumber, TimeGenerated
  ,EventId,EventType,EventTypeName,EventCategory,EventCategoryName
  ,SourceName,REPLACE_STR(Strings,'\u000d\u000a','.') AS Strings
  ,ComputerName,SID,REPLACE_STR(Message,',','.') AS Message,Data 
INTO  C:\EventLog\Security_%date%.csv 
FROM Security
WHERE TimeGenerated > SYSTEM_DATE() 

And I call log parser from Windows power shell like :

.\LogParser.exe -o:CSV file:sqlfile.sql?date=.....

what can I put after "date=" so that I can get the current date in the format of yyyyMMdd?

logparser