Hi!
I have a table with a tent_recpdat field (date of receipt of the goods of type date (dd-mm-yyyy)), I need to make a select that brings me the results of receipts that are more than 50 days old, I tried the sql command below, but no results.
select tent_fornece_1, tent_nomefor_1, tent_nronota_1, datedif(day, tent_recpdat_1, getdate()) as dif_dias from notent where dif_dias > 50