[AccessD] datediff & format

[Heenan, Lambert]

If it's within on day. :-)

Lambert  


-----Original Message-----
From: Heenan, Lambert 
Sent: Friday, May 26, 2017 9:43 AM
To: 'Access Developers discussion and problem solving'
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