How a date from a text "20141031"

[Newby]

I am able to create year, Month, and day by using Val(left([],4)) , mid and right.



When I try to put it back together using Date(Yr,Mon,day) does not work. This should be simple.

Thanks in advance

[JoeM]

In Access, the function to use is DateSerial, i.e.
DateSerial(Yr,Mon,day)

See: https://support.office.com/en-US/Art...a-93f2b046f503

[ranman256]

year(date) & month(date) & day(date)

[June7]

ranman, the value is text, not a valid date, so Year(), Month(), Day() won't work.