Date calculation

Sure, although there is no specialized operator. But you can do this within the data feed. Use the column convert data type operator to convert your date into number. Once a number represents a date it counts the number of milliseconds since 1970 (the way Java or Unix deals with dates).

Now you can do calculations. Of course you need to divide the result to get human readable results, e.g. by converting ms into hours.

Please expect enhancements in this area in the next version of MashZone.

Thanks, this is very helpful and also thanks for the quick reply. I am convinced that this kind of service is one of the successfactors of Mashzone.

Greetings,

Hans

Hi,

Any enhancements regarding this topic?

I'm currently trying to do the same gap calculation and an easiest way to do it could be a good thing to convince my customer.

Many thanks and regards,

Nicolas