I want a calculated dataprovider that works out the elapsed time (in minutes and seconds) between two datetime values.
I have tried loads of different syntaxes but can get it to work. I have defined the calc field as DATETIME and the defination as:
result = eventdate - sessions.startdate;
this works as far as it goes. It does at least display a ‘date’ value which is the result of the subtraction - but how do I turn it into minutes & secs?
I thought valueOf would work but it seems to require an INT as a parameter and I cant find any other functions that turn dates into numeric values?
ideas?
Al.