I have two columns Which are stored as Integer !
1) Date : Integer field and contains MMDD
2) Year : Integer Field and Contains YYYY
How do i combine or join or union and display them as MMDDYYYY and also once i convert can i filter the date with values ???