Forum Discussion

bishnu's avatar
bishnu
Icon for Helper II rankHelper II
6 years ago
Solved

Error in date when formatting to date

I having problem when i changing (text to date type).

the original format is d/m/y, but when i am changing text to date type its randonly changing format to d/m/y and m/d/y

On to the left is original  and to the right is the one after i chnaged to date format. 

 

Can anybody help me to figure out why is this hapenning. I tried to extrat day and month/year seperately and later remerge, but the end result is the same.

 

Thanks in advance

 

BB

Need Help
  • az38's avatar
    az38
    6 years ago

    bishnu 

    try column

    fld_due_date Copy = DATE(MID([fld_due_date],7,4),MID([fld_due_date],4,2),LEFT([fld_due_date],2))

    it looks like regional settings issue 

4 Replies