开发者

date time calculation that was 6 hours ago

开发者 https://www.devze.com 2023-04-04 18:05 出处:网络
I am using crystal XI and I want to run a report where the admit date was within the last 6 hours of the report runtime. I\'m not sure how to calculate thi开发者_运维知识库s. Add the following to your

I am using crystal XI and I want to run a report where the admit date was within the last 6 hours of the report runtime. I'm not sure how to calculate thi开发者_运维知识库s.


Add the following to your report's record-selection formula:

//show all admission dates that have occurred more recently than 6 hours 
//before the current date/time
//replace {table.field} w/ correct value
{table.field} >= DateAdd("h", -6, DataDate + DataTime)
0

精彩评论

暂无评论...
验证码 换一张
取 消