Forum Discussion

niv_qrm's avatar
niv_qrm
Frequent Visitor
4 years ago
Solved

Pasre date giving error

Hi,   I am not sure what I am doing wrong, but when I try to Parse date I am getting error after 13th of the month. I have done this before and worked previously but for some reason I am getting e...
Need Help
  • niv_qrm's avatar
    niv_qrm
    4 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi niv_qrm ,

 

See the sample input values, they're DD/MM/YYYY, but your column from 'from example' is MM/DD/YYYY, so it will be wrong.

 

Local try to choose English (United Kingdom)

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

niv_qrm's avatar
niv_qrm
Frequent Visitor
4 years ago

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.