Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
3442 Vistas

There is a report "Tasks Analysis" in module "Project". It has a field "#Days to deadline". This field is displayed as "Float". Can I somehow format this field so that it is displayed as integer (rounded float)? How to do it? Thank You. 

Avatar
Descartar
Mejor respuesta

Hi Willmore,

Update task analysis select query to ((extract('epoch' from (t.date_deadline-(now() at time zone 'UTC'))))/(3600*24))::NUMERIC::INTEGER as delay_endings_days

Avatar
Descartar
Autor

Thank you!:)

Publicaciones relacionadas Respuestas Vistas Actividad
0
dic 24
973
4
ago 20
4885
1
dic 19
3712
2
jul 19
3914
1
sept 18
3249