跳至內容
選單
此問題已被標幟
1 回覆
3429 瀏覽次數

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. 

頭像
捨棄
最佳答案

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

頭像
捨棄
作者

Thank you!:)

相關帖文 回覆 瀏覽次數 活動
0
12月 24
969
4
8月 20
4880
1
12月 19
3712
2
7月 19
3906
1
9月 18
3247