Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
3628 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
1291
4
ago 20
5196
1
dic 19
3937
2
jul 19
4171
1
sept 18
3469