‎04-30-2013 10:20 PM
Solved! Go to Solution.
‎05-01-2013 10:41 AM
Convert(nvarchar,tblAssetCustom.WarrantyDate,101)
‎05-08-2013 11:07 PM
Case when tblAssetCustom.Warrantydate is null then 'Unknown' when tblAssetCustom.Warrantydate < GetDate() then 'Expired' else 'In Warranty' end As [Warranty Status]
‎05-01-2013 08:04 PM
‎05-01-2013 08:23 PM
GreenCup wrote:
Thanks!!
Here is another SQL query question...
I want a column, As Warranty Status, in a report that states "In Warranty" or "Expired"
This is the statement I have in mind:
If tblAssetCustom.WarrantyDate is less than Today put "Expired" As [Warranty Status]
Else put "In Warranty" As [Warranty Status]
Is there a way to accomplish this?
‎05-01-2013 08:45 PM
GreenCup wrote:
Managed to figure out
Case when tblAssestCustom.Warrantydate < GetDate() then 'Expired' else 'In Warranty' end As [Warranty Status]
‎05-01-2013 10:41 AM
Convert(nvarchar,tblAssetCustom.WarrantyDate,101)
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now