[AccessD] A2K: This should be easy

Darren Dick d.dick at uws.edu.au
Sun Mar 16 21:15:01 CST 2003


Hi John
Many many thanks. It was easy.
<sigh>. It's only 2:15pm Monday afternoon here - Time to go home me thinks
Again many thanks

Darren


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Ruff
Sent: Monday, 17 March 2003 2:03 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] A2K: This should be easy


The DateAdd function should work

    DateAdd("n", -15, txtStartTime)


John V. Ruff - The Eternal Optimist :-)

"Commit to the Lord whatever you do,
	and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Darren Dick
Sent: Sunday, March 16, 2003 6:46 PM
To: Access Mail Group
Subject: [AccessD] A2K: This should be easy


Hello all
This should be simple.

I have a control on a form (txtStartTime). Formatted for Short time (i.e.
hh:mm)
I want to take say...5, 10 or 15 minutes from whatever time is in
txtStartTime

So take away 15 from 11:00 should give me 10:45

How do I do this.

<Sigh> this should be easy. It probably is, I'm just brain fading.

Darren

_______________________________________________
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



More information about the AccessD mailing list