![enter image description here](https://i.stack.imgur.com/Cwwj5.png)Alright I know many of my questions are based on date formats but here is my problem. I am working with a field, lets call it `ABCTIME`, its saved in numeric format and is displayed as such `20110517151750` ie `2011-05-17:15:17:50`. I need to be able to convert this into a date or `datetime` so I can use a `datediff` to show all records that are greater than or = to todays date (`GETDATE`). Also, I cannot change the format of the table. Any help would be greatly appreciated. Thanks - 

edit- I need to show all records that are 1 year or greather than todays date.