Skip to Content
Menu
This question has been flagged
1 Atsakyti
3445 Rodiniai

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. 

Portretas
Atmesti
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

Portretas
Atmesti
Autorius

Thank you!:)

Related Posts Replies Rodiniai Veikla
0
gruod. 24
974
4
rugp. 20
4887
1
gruod. 19
3714
2
liep. 19
3914
1
rugs. 18
3251