When building a custom report and you use the Between statement, how do you get the values to go between? For example, a canned report that is for the availability 'yesterday' has this SQL statement to grab the time frame:
WHERE
( DateTime BETWEEN 37999 AND 38000 )
How do you come up with the 37999 and 38000 values?