+ Start a Discussion
Matty BMatty B 

Wave Analytics Get Hours Between 2 Dates

I need to be able to calculate the number of hours between 2 date fields. In Wave Anlytics this doesn't seem to match with the available operators (COUNT, SUM, etc.).

I would think it should be able to be handled rather than importing this calculation in the actual ETL. Which approach should I be taking (SAQL or Compare tables or something else)?
SandhyaSandhya (Salesforce Developers) 
Hi Matty B,

Please refer developer guide page no 36 what date functions you can use.

https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_saql.pdf

Hope this helps you!

If this helps you mark it as solved.

Thanks and Regards
Sandhya