Session duration in QV V12

[reijk317]

Hello,

I have a problem with session duration and the solutions here in this forum doesn't work for my.

It will work if I put a time in the expression, but not when I use the fieldname.

interval(0.002963,'hh:mm:ss')

interval([Session duration],'hh:mm:ss')

[marcus_sommer · Accepted solution]

Your field won't be interpreted as a numeric value and therefore the formatting failed. This means you need to convert this field with the default-variables of your application (be careful - it's a global setting) or with a function like num#() or maybe just with some replace like: replace([Session Duration], chr(46), ','). It depends on your data and your requirements which way is the most suitable.

- Marcus