Skip to Content
Menu
This question has been flagged
1 Odpoveď
3610 Zobrazenia

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
Zrušiť
Best Answer

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
Zrušiť
Autor

Thank you!:)

Related Posts Replies Zobrazenia Aktivita
0
dec 24
1269
4
aug 20
5184
1
dec 19
3929
2
júl 19
4162
1
sep 18
3456