How to handle Date format while Import From Text/csv File

udayrmer

Hello,

I am Importing Text/CSV File, It have date in various format
i.e. yyyymmdd
dd-mon-yyyy
mm-dd-yyyy

and my system format is dd-mm-yyyy.

how to store it to nav, I had used evaluate function but it misinterpreting it.
i.e. for yyyymmdd to yy-yy-mmdd

Thanks in advance

gerrykistler

You would have to have some indicator in the text file as to which format a particular date is in. There really isn't any way because you could have 06-05-2012 which could be 6 May or 5 June.

udayrmer

ok Thanks