Difference between two Date Fields

D

david.millar

I have two date fields, "Approved" and "StartDate" that stem from date
pickers.

I would like to do a calculation to find out the no of days difference
between these two fields and publish it on the same form in a field
called "DaysToFill".

I tried to use the code in the posting "Date minus Date" but was
unsuccessfull.

Can soemone help with this. I have no programming experience so will
need walked through it.

Thanks
 
N

Nic Roche

I tried to use the code in the posting "Date minus Date" but was
unsuccessfull.
Click to expand...

<snip src="MSDN">

Function DiffADate(theDate)
DiffADate = "Days from today: " & DateDiff("d", Now, theDate)
End Function

</snip>


Nic Roche
 
D

david.millar

I am not sure. The advice that was posted in the "Date minus Date" post
says to use Microsoft script editor.
 
T

T.Coita

Or you can convert your date in julian and add the number of day that
you wan't and after convert in your standard date!

julian : 2 january 2005 is 2.2005

Hope this help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the difference between two date picker 8
Calculating the difference, in hours, between two date/time in two different time zon 2
Date subtraction 1
Yet another Date Picker Calculation 3
Date Calculation, Find Difference between two dates 5
How to calculate difference between two date & time along with working hours and days 2
Date Diff Calculation VBScript - Help Repeating Section 10
Date Calculation Again, please help 1

Top