[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