DIFFERENCE BETWEEN CURRENT DATE/TIME AND SET FIX DATE/TIME

[ann1]

Hi Guys
Using V9 and SQL. I could do with some help on this one ...
I need to calculate the time in "days/hours/minutes" left between the current date and time (when the report is run) and the set "must fix by" date and time taking into account business hours and holidays.

I have tried Ken H's formula but seem to be getting into a mess with it ... any help would be appreciated.
Thanks

 

[bdreed35]

Please post your formulas and some sample output to help us visualize what you are currently doing.

~Brian

 

[synapsevampire]

The long term solution is to create a Periods table, which contains whatever dimensions you require, such as date, business day, holiday, weekend, hours.

Now you can do a Left Outer to your data and you have what you need. Other solutions will require that you keep manually coding what is built into every data warehouse for precisely this reason.

I have posted SQL code here to cerate a SQL Server period table in the past, if by SQL you mean MS SQL Server, do a search and you should find it.

-k

 

[Reebo99]

see my response in thread767-718833

Reebo
UK