When datepart ( week, )= datepart ( week, convert (, getdate (),( 0 ))) AND datepart ( month, )= datepart ( month, getdate ()) AND datepart ( year, )= datepart ( year, getdate ()) then 'WEEK' When datepart ( day, )= datepart ( day, convert (, getdate (),( 0 ))) AND datepart ( month, )= datepart ( month, getdate ()) AND datepart ( year, )= datepart ( year, getdate ()) then 'TODAY' When < convert (, getdate (),( 0 )) then 'OVERDUE' I'm doing this directly in a computed column:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |