G Guest May 19, 2004 #1 i am trying to take a date in a date field and add the next month then get the difference in days, please help
i am trying to take a date in a date field and add the next month then get the difference in days, please help
E Elwin May 19, 2004 #2 Dim dte as Date Dim intDays as Integer dte = #1/1/2004# intDays = DateDiff("d",dte,DateAdd("m",1,dte)) -----Original Message----- i am trying to take a date in a date field and add the Click to expand... next month then get the difference in days, please help
Dim dte as Date Dim intDays as Integer dte = #1/1/2004# intDays = DateDiff("d",dte,DateAdd("m",1,dte)) -----Original Message----- i am trying to take a date in a date field and add the Click to expand... next month then get the difference in days, please help
T Tim Ferguson May 20, 2004 #3 i am trying to take a date in a date field and add the next month then get the difference in days, please help Click to expand... It's the same as the number of days in the current month, so: Day(DateSerial(Year(MyDate), Month(MyDate)+1,0) Tim F
i am trying to take a date in a date field and add the next month then get the difference in days, please help Click to expand... It's the same as the number of days in the current month, so: Day(DateSerial(Year(MyDate), Month(MyDate)+1,0) Tim F
