Trying to Bulk update some dates to 1/Jan/2099 but the bulk uploader is changing them to 1/Jan/1999.

[Charlie Bethune]

When I try to use the date picker to set a date of 1/Jan/2099 it sets the date to 1/Jan/1999. whejn i try to bypass the the date picker it give the error  "Please enter the date in the format "d/MMM/yy"."  How do I bulk change dates to the year 2099?

[Tessa Tuteleers · Accepted solution]

Hi @Charlie Bethune , 

fun question, and kudos to you for planning that far ahead into the future! I can't even plan what I need to do for dinner correctly :D 

I guess your date format is "dd/mmm/yy", so the year is 99 which still refers to 1999. The only way I got it to work in bulk is by actually changing the date format of your site to use the full year. i.e. : 

-> 

Then, you can bulk-update to 2099, and after you're done, you can revert them back to their original value of "yy" safely. 

Kind of an annoying workaround but it should work. 

- Tessa