Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add minutes to date / time 1

Status
Not open for further replies.

gmman

Technical User
Feb 14, 2004
26
US
I am trying to add two field together one has a date/time and the other is minutes. If I add them straight together it adds to the date. How do I get it to add to the minutes.

Thanks for any help!
 
dateadd("n",30,{YourDateTimeField})

The above will add 30 minutes to the datetime field. Use a -30 to subtract 30 minutes.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
Thanks so much it worked great. I tried every way but the easy way. Thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top