![]() ![]() |
Reference Type: Supported, Category: Date Functions, ICR#: 10103
The $$HDIFF^XLFDT extrinsic function returns the difference between two $H formatted dates.
$$HDIFF^XLFDT(x1,x2[,x3])
x1: |
(required) $H date (in quotes). |
x2: |
(required) $H date (in quotes) to subtract from the x1 date. |
x3: |
(optional) If NULL, `$D(x3), return the difference in days. Otherwise:
|
returns: |
Returns the $H difference. |
Return the $H difference in days.
>S X=$$HDIFF^XLFDT("54789,40523","54786,25983",1) >W X 3 |
Return the $H difference in seconds.
>S X=$$HDIFF^XLFDT("54789,40523","54786,25983",2) >W X 273740 |
Return the $H difference in days hours:minutes:seconds format (DD HH:MM:SS).
>S X=$$HDIFF^XLFDT("54789,40523","54786,25983",3) >W X 3 4:02:20 |