Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Calculating Lead time

I would like to learn how to calculate leadtime in VBA.  I have a txtbox that has a date.  Formatted as date.  I have a txtbox that has a number.  I have another box that is a calculation of the two.  Example

txtbx1
10/29/08

txtbx2
10

txtbx3
needs to equal 10 weeks in the future starting on 10/29/08.  

I have a work around adding another txtbox4.  which is calculated as =txtbx2*7.  Then
txtbx3 is calculated as =txtbx1*txtbx4.

There has to be another way.  This question is strictly for learning and not any emergency. It would be nice to learn a new trick

net
0
get-ADuser -F ($_.Name -eq "Todd")
Asked:
get-ADuser -F ($_.Name -eq "Todd")
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  Take a look at DateAdd() in the on-line help, which is used to add a date plus a period.  It can be used anywhere an expression is valid (ie. a control source), and the arguments passed can be references to other controls on your form (ie.  Forms![<myFormName>]![<myControlName>].

HTH,
JimD.
0
 
get-ADuser -F ($_.Name -eq "Todd")Systems AdministratorAuthor Commented:
BINGO!

=DateAdd("ww",[Text2],[Text1])

Thanks!

net
0
 
get-ADuser -F ($_.Name -eq "Todd")Systems AdministratorAuthor Commented:
Great Help As Always!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now