Hi there, I tried to parse the info in "cs-uri-stem", In "cs-uri-stem" it contain a string like " /Demodir/_233_demo.gif" I just want to parsed the "233" . So I used CharIndex. I tested in CharIndex on SQL and it worked, but once I run it in LogParser it failed...

You can use the "to_string" function to re-format the date to your preference. Here are some examples if your log contained the date of "2006-01-25" logparser "select to_string(date,'MM/dd/yyyy') from logfile.log" Returns: 01/25/2006 logparser "select to_string(date,'dd.MM.yyyy') from logfile.log" Returns...

i try to export IIS Output. Every thing is fine, yust the dateformat is wrong. mm/dd/yyyy is in "Old-Germany" --> dd.mm.yyyy Switch ' -local EF ' is only for IIS Input !? Regards for any hint, German-#5