• I don't have a problem to get a random month or a day I just using this :

    UPDATE table_a

    SET column_a= DATEADD(DAY, ABS(CHECKSUM(NEWID()) % 3650), '2015-01-01')

    But the column that I'm trying to populate is a 'credit card expiry date' and it need to be '2015/01' (yyyy/mm).