Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
3420 Prikazi

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
Opusti
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
Opusti
Avtor

Thank you!:)

Related Posts Odgovori Prikazi Aktivnost
0
dec. 24
968
4
avg. 20
4878
1
dec. 19
3710
2
jul. 19
3905
1
sep. 18
3247