Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
1 Beantwoorden
3459 Weergaven

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
Annuleer
Beste antwoord

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
Annuleer
Auteur

Thank you!:)

Gerelateerde posts Antwoorden Weergaven Activiteit
0
dec. 24
976
4
aug. 20
4890
1
dec. 19
3716
2
jul. 19
3916
1
sep. 18
3254