Convert YYYYMMDD number to DD.MM.YYYY format

[ckunath]

Hello,

I am trying to convert a field value which contains a number in timeformat YYYYMMDD to DD.MM.YYYY

I tried several converting methods but it always end up with a whacky date, not the one that I require.

Can anyone help me out?

[richgalloway · Accepted solution]

This should do the job.

... | eval bar=strftime(strptime(foo, "%Y%m%d"),"%d.%m.%Y") | ...

[ckunath]

Thanks alot!