Convert Long number into Date in access vba -

Convert Long number into Date in access vba -

i having field contains date in form of number , need convert equivalent date farther operations such checking between date other date variables.

for illustration : long number variable

dim ndate long ndate=20140901

i need ndate date variable such 01/09/2014 (dd/mm/yyyy)

thanks in advance

dim actualdate date actualdate = dateserial(ndate\10000, (ndate mod 10000)\100, ndate mod 1000000)

dateserial takes arguments year, month, day. \ operator performs partition discarding remainder, , mod performs partition returning remainder.

vba date access-vba