Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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]
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment