Pasre date giving error

Hi Anonymous,

Thanks for your reply. I figured out the mistake but forgot to come and check the replies here.

This table is a mix of data coming form different systems with different date formats.

So I seperated those ones with different format, then split the date and concatenated it and then used parse date and it fixed. For some reason when I try parse date isn't working when the data date format in US format. I tried using the Locale with UK, UAE but still I kept getting error. This is the only way I could fix it. 

Thanks a lot for the replies.