Pasted

CONVERT a NUMERIC FIELD INTO an actual DATE:
DATEPARSE(“yyyyMMdd”, STR([DATE]))
 
Counting Days WITHIN a Dynamic DATA SET:
MAX(DATETRUNC('day',[DATE TIME]))-MIN(DATETRUNC('day',[DATE TIME])) + 1
 
Subtract hours FROM DATE:
DateAdd('hour', -4, [DATE FIELD])
 
Combine DATE AND TIME FROM two different FIELDS:
DATEADD(
    'hour', DATEPART('hour', [ORDER TIME]), 
    DATEADD(
    'minute', DATEPART('minute', [ORDER TIME]), 
    [ORDER DATE]
    )
)