DateTime fields in GROUP BY, manual relations and offline data
Hi,
1.
Is it possible to make OQL statements for DateTime fields,
statements to extract grouped data like to get average per day over one month or similar.
Here is an examples of MS SQL statement, where we get
grouped records of sum,max,...., per ours:
Also pay attention to DATEPART function ....
'SELECT
DATEPART([YEAR], ...