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?