[AccessD] datediff & format

[Kostas Konstantinidis]

HI Heeman,

Your suggestion works but with some changes....
Just to know how it substituted for Greek MS Office version

hours: Format(([TimeOUT])-([TimeIN]);"ωω:λλ:δδ")
I don't know if your windows version can display the above Greek characters
for date format In free translation something like "ww:ll:dd" :-))

Thanks
/kostas



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Heenan, Lambert
Sent: Friday, May 26, 2017 4:43 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] datediff & format

Kostas,

No need for DateDiff, just subtract the two dates.

Print format(now()-date(),"hh:mm:ss")
09:41:17

Lambert  


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kostas Konstantinidis
Sent: Friday, May 26, 2017 4:56 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] datediff & format

Hi all,
In a time tracking I use the datediff
hours: (DateDiff("λ";[TimeIn];[TimeOut]))/60

but what I really need is to track the time difference result in format as
hh:mm

Could anyone help please?
Thanks
/kostas


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com