Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
3464 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Penulis

Thank you!:)

Post Terkait Replies Tampilan Aktivitas
0
Des 24
981
4
Agu 20
4895
1
Des 19
3717
2
Jul 19
3917
1
Sep 18
3263