Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
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