Isn't the built-in published date column what you should use? If you enter the correct values, you can sort/search however you want.
In any event, you can do what you want with bulk metadata search/replace.
Mode: regular expression
Source field: is your int column.
Search for: (.*)
Replace with: \1/01/2000 (assuming you use dd/mm/yyyy dates)
destination field: your date column
This only works if there is actually something in the int column, and only if the value is less than 31.
|