Hi All,
I have a field called vaccinationdate in a table with datatype DATE, but the values of that field have different formats. now I cant change the datatype of this column and the client says this is how the values will be since in case if the patient doesn't know the exact date of vaccination they would just mention the month and year. please help me to insert these values in the table.
ex: Values are like:
06/17/2016
07/12/2016
07/2016
05/28/2016
02/2016
Please help.
Thanks in advance for your help!