Skip to Content
Mar 11, 2021 at 08:40 AM

How compare date times from different queries.

60 Views Last edit Mar 11, 2021 at 09:56 AM 3 rev

Good afternoon:

I have two queries. on first, I have a values of fuel rate by second of many equipment. in second query, I have diferent ranges of time by equipment.

I want get sum of fuel rate between any range of time.

I merge variables Equipo1/Equipo2, and FECHA1/FECHA2. But I can´t compare date times, and calculate the sum. I tried with this formula but it don't works. appears message #INCOMPATIBLE:

sum fuel rate = sum ([fuel rate] where ( [tiempo]>[INICIO] and [tiempo]<[FIN])

please, could you help me?




msdci.png (23.2 kB)
ax7xy.png (10.5 kB)