All dates must be in the following format: DD.MM.YYYY. All times must be in the following format: h:mm:ss. The hour must be in 24 hour format and may be one (0-9) or two digits (10-23). The from variable must be included first, then the to variable.

The time range for tools uses the following case sensitive parameters:

  • all: all the time (without restriction)
  • today: from today 0:00:00 to the current time today
  • yesterday: from yesterday 0:00:00 to today 0:00:00
  • tomorrow: from tomorrow 0:00:00 to the day after tomorrow 0:00:00
  • this week: from first day of current week 0:00:00 to current time today
  • last week: from first day of last week 0:00:00 to first day of the current week 0:00:00
  • this month: from first day of current month 0:00:00 to the current time today
  • last month: from first day of last month 0:00:00 to first day of the current month 0:00:00
  • this year: from first day of current year 0:00:00 to the current time today
  • last year: from first day of last year 0:00:00 to first day of current year 0:00:00
  • daily: from current time 1 day ago to the current time today
  • weekly: from current time 7 day ago to  the current time today
  • days=x: from current time x days ago to the current time today
  • start=s end=e: from s to e
  • start=s days=x : from s to s + x days
  • end=e days=x: from e -x days to e
  • floatend=xMOD1 MOD2=y - calls between now and (y MOD2 - x MOD1); BETWEEN SQL statement, where the time period is like a range between MOD1 and MOD2 (older than MOD1 and newer than MOD2)
    MOD = minutes, hours, days
    for example: floatend=5minutes days=15 means all calls older than 5 minutes and less than 15 days old.
  • older than x MOD - calls older than x MOD; MOD = minute, minutes, hour, hours, day, days, month, months)