Home / server / Questions / 533726
Accepted
Fidel
Asked: 2013-08-26 23:32:26 +0800 CST

log parser doesn't interpret dates correctly

  • 772

When I query our IIS logs, I get a value of '30/12/1899' in the date column.

select * from 'C:\IIS 2013 Logs\*.log'

However for some rows, it does have a valid date. (Coincidently rows that have a day number less than or equal to 12) So immediately you can tell it's a date formatting issue.

Our IIS is logging in american date format (mm-dd-yyyy) - I cannot change this. Our server however runs on UK date format (dd-mm-yyyy).

Is there an extra argument I can give log parser so that it grabs the dates correctly from our americanized logs?

iis

1 Answers

  1. Best Answer

    You can use the -locale:USAcommand-line flag to tell logparser that the dates in the log are in US format.

    • 3