Skip to Content
Menu
Dette spørgsmål er blevet anmeldt
1 Svar
3462 Visninger

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
Kassér
Bedste svar

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
Kassér
Forfatter

Thank you!:)

Related Posts Besvarelser Visninger Aktivitet
0
dec. 24
979
4
aug. 20
4894
1
dec. 19
3717
2
jul. 19
3917
1
sep. 18
3261