Doughnut01
New Member
Hi,
I have a large amount of data being received weekly. i need to pull the dates from it, which arrives in a column of information with some text.
It all has a standard layout of "YY.MM.DD Text"
I've been able to pull the dates from this, but the system keeps reading the info as "DD.MM.YY"
For example something from today which should be "19(YY).12(MM).03(DD)" is only ever being read as "19(DD).12(MM).03(YY)"
Any guidance on this would be greatly appreciated.
I have a large amount of data being received weekly. i need to pull the dates from it, which arrives in a column of information with some text.
It all has a standard layout of "YY.MM.DD Text"
I've been able to pull the dates from this, but the system keeps reading the info as "DD.MM.YY"
For example something from today which should be "19(YY).12(MM).03(DD)" is only ever being read as "19(DD).12(MM).03(YY)"
Any guidance on this would be greatly appreciated.