Time field is filled with "0:00:00" problem

[Former Member]

Dear,

I have three fields "Actual Hours","Actual Start","Actual End".User can fill "Actual Hours" or "Actual Start","Actual End" and calculate "Actual Hours" by "Actual Start" and "Actual End".

If the  "Actual Start" field is filled with 0:00:00,  if using the actual end time to minus the actual start time, the result should be 16, but the result is empty. 

Quick feedback will be appreciated!

Best regards,

Hu Hongfeng

Tags edited by: Michael Appleby

[jason_latko]

Hu,

Not sure what you are trying to do.  Can you please clarify your requirement?  Also, why are you using the special values?

Jason Latko - Senior Product Developer at SAP

[Former Member]

Dear Jason,

Thanks for your replay!

I want to calculate 'Actual Hrs' by 'Time' and 'To' or directly fill the 'Actual Hrs' without 'Time' and 'To' ( that why i use special values)

Now when the 'Time' is filled with '0:00:00', it may judged none (you didn't fill any value).

e.g.

The 'Time' field is filled with '0:00:00' and the 'To' is filled with '8:00:00'. The correctly value of 'Actual Hrs' should be '8', but now can't calculate.

Best Regards,

Hu Hongfeng

[jason_latko]

Hu,

Please post a screen shot of your update rule from the Actual Hours field.  I would think the rule should be as simple as the DIFF between To and Time fields:

DIFF

     SCREENFIELDVALUE

          To

     SCREENFIELDVALUE

          Time

Jason Latko - Senior Product Developer at SAP

[Former Member]

Dear,

The screen shot is the rule of Actual Hours field.

Best Regards,

Hu Hongfeng

[bill_froelich]

Hu,

What type of fields are ActualEnd, ActualStart and ActualHrs?  Are they DateTime fields in your object or String fields?

--Bill

[Former Member]

Dear,

ActualStart and ActualEnd are Integral Number

ActualHrs is Decimal

I think the main problem should be when ActualStart("Time") or ActualEnd("To") is filled with '0:00:00', it may judged none (you didn't fill any value).

Best Regards,

Hu Hongfeng

[bill_froelich]

Why not use actual Agentry Date Time fields instead of integral numbers?

--Bill

[Former Member]

Dear,

Because the field in database is integral number.

If set ActualStart and ActualEnd to Time field,have the same problem too.

Best Regards,

Hu Hongfeng

[bill_froelich]

Wouldn't you just subtract the values rather than converting to date strings in the rule?