I have the following script in my load script.
Where logdate >= '01/01/2011'
The above script loads the calls from the call_table for anything equal to or greater than the 01/01/2011. However what I am looking to do is create the script so it picks up a number of days. So therefore when I load my report, instead of it loading everything from 01/01/2011, it will load the last 1460 days. Is this possible to do.
My logdate field is a TimeStamp format and shows as 01/01/2012 00:00:00, so if I try and convert to a number it shows something like 45986.2689898.