跳至内容
菜单
此问题已终结
1 回复
3417 查看

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
968
4
8月 20
4876
1
12月 19
3709
2
7月 19
3902
1
9月 18
3247