My data has dates very very wrong extending to 8201 Year and now I can either remove all the data where Year is more +- current year, but I am thinking of making all the dates which are above a certain date like today+5year to be maximum of 31-12-2099 something like that in floor value, due to date being so out of range Date Picker isn't working and fields tags take it as numeric instead of date I have used floor everywhere for my date values.
P.S. I have already tried advance settings they don't work either, while selecting dates in date picker it says no data available and dates are grey not black like normal.
Thanks & Regards,
Please Accepts as Solution if it solves your query.
