I'm using a datagrid to show information. It's data comes from a few sql tables. One table contains JRNL.DATE. It shows its type as 'smalldatetime'. It's formatted like this: YYYY-MM-DD TT:TT:TT
I need some help calculating how old each record is based on today's date.
Do I need to go this route:
or is there something easier?
This will be used in an asp.net page.