substract dates 2

[GusRam]

Example: endtraveldate - starttraveldate should give me the number of nights,
I need to know how to create a number of nights fact.
The dates are datetime datatypes.

Thanks

 

[kpescatore]

Create a metric using an applysimple.

This is and example for SQL Server your DB may be different

Sum(ApplySimple("datediff(dd,#0,#1)", [starttraveldate], [endtraveldate])) {~}

 

[iolaper]

Hey kpescatore,
I was wondering if there was any resource which would describe more elaborately how to use the applysimple, applyagg etc where I could refer to in relation to SQL SERVER 2000 that is.

Thanks!!

 

[kpescatore]

Hi asudevil,
I don't know of any resource currently. If I find one I will post it.

Sorry