i have the following query which runs perfectly fine, meaning it gives me some results.
what does arsdate -1 imply?
arsdoc query -v -h ORSAPOH1-PHYS -u admin -p ondemand -f 'System Load' -i "where input_filename like '%%' and load_time between -1 and 1376989200"
Hello Pankaj,
since the date in CMOD is a internal numerical representation of a date, AND since the number is between 0 and max(Integer), then a -1 means only that you are sure you get everything from before the day 0 :-D
Sincerely yours,
Alessandro
Day 0 is January 1, 1970.
on the large value, it is the seconds from 01/01/1970 at midnight.
You can produce any midnight value in Excel using 86,400 * (date - 01/01/70)