I have always had trouble understanding the syntax for datetime in historical SWQL queries. I would so greatly appreciate it if someone could tell me if the below queries are properly formatted:
- Last 30 Days:
- DateTime field >= AddDay( -30, GETDATE())
- Last 24 hours:
- DateTime field >= AddHour( -24, GETDATE())
- Last Month (calendar):
- DateTime field BETWEEN DATETRUNC('MONTH', ADDMONTH(-1,GETDATE())) AND DATETRUNC('MONTH', ADDMONTH(1, GETDATE()))
- Last Quarter (calendar):
- DateTime field >= DATETRUNC ('QUARTER', (ADDMONTH(-3, GETUTCDATE()))) AND DATETIME <DATETRUNC ('QUARTER', (GETUTCDATE()))
- This Month:
- DateTime field >= DATETRUNC ('MONTH', GETUTCDATE()) ???????
- Year-to-Date:
- DateTime field >= DATETRUNC ('YEAR', GETUTCDATE()) ???????
