Calculating the difference between two dates in SQL with the result in days Simon Hutchinson

​[[{“value”:”To calculate how many days difference there is from the date I wrote this post, I first need to convert the field ENTERDTE from a packed numeric to a “true” date, and then I can perform the calculation using it.
For example I need a list of customers who have not paid in over 90 days.”}]] Read More