HI,
I have a date column in julian type that is based on Hijri calendar and I want to change the type of this column to date formate.
I changed the format from whole number to text then using locale I changed it to date type in our locale. I checked the data loading ane reigon format setting option too. but I faced to "We couldn't parse the input provided as a Date value." for just 1 percentage of data in this column. in detailed it seems there are 5 specific days in solar hijri calendar which faced with error and repeat for all years after that.
How can I solve this problem?
Thanks in advance
somayeh
in the picture, we see the 0229,0230,0231,0431 and 0631 is repeated for each year (1393,1394,..)
