Setting a new value

[Calvin Shane]

If I want to set a field called DateClosed into two
values, both of whom will be used in a later calculation,
do I set the new value as:

DateClosed2: DateClosed (in my query), or
DateClosed: DateClosed2

I will use both separately in a calculation:

MTTR: Datediff[DateCreated],[DateClosed2])/60 AS MTTR
"x.xx" where x is hours, and xx is
hundredth hours

MTBF: Datediff[DateClosed],[DateCreated])/60 AS MTBF
in same format as above

Any thoughts?

CALVIN

 

[Les]

Hi,
I'm not sure why you need 2 fields. You can use the
same field in both calculations.