Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
3593 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
1257
4
ago 20
5179
1
dic 19
3928
2
jul 19
4154
1
sept 18
3451