Subtracting two dates in VBA

[Fredek]

Hi

If I have two dates in text format (20180329and 20180424) how can I work out the number of days between them?

I need this to be in VBA as the two datesare coming from Access forms. Subtracting only works for dates in the samemonth. Can I convert them into dates in VBA and then use a DATEIFF?

 

[wideboydixon]

daysDiff = DateSerial(CLng(Left(date2, 4)), CLng(Mid(date2, 5, 2)), CLng(Right(date2, 2))) - DateSerial(CLng(Left(date1, 4)), CLng(Mid(date1, 5, 2)), CLng(Right(date1, 2)))

WBD