Skip to Content
Menu
This question has been flagged
1 Reply
2753 Views

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
Discard
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
Discard
Author

Thank you!:)

Related Posts Replies Views Activity
0
Dec 24
30
4
Aug 20
3826
1
Dec 19
2711
2
Jul 19
2891
1
Sep 18
2585