Converting Text to Number?

[Anastasia333]

I have a linked table that I'm working with dates defined as text (in the
format 25NOV without the year) and I'm trying to extract the date (25) and
use it as a number but I can't figure out how to do it - is it possible?

[Alex Dybenko]

Hi,
try:

Val(Left([Myfield],2))
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by Anastasia333
I have a linked table that I'm working with dates defined as text (in the
format 25NOV without the year) and I'm trying to extract the date (25) and
use it as a number but I can't figure out how to do it - is it possible?

[Bill]

who knows how to write south african

Post by Anastasia333
I have a linked table that I'm working with dates defined as text (in the
format 25NOV without the year) and I'm trying to extract the date (25) and
use it as a number but I can't figure out how to do it - is it possible?

[austin brewster]

Post by Bill
who knows how to write south african

Post by Anastasia333
I have a linked table that I'm working with dates defined as text (in the
format 25NOV without the year) and I'm trying to extract the date (25) and
use it as a number but I can't figure out how to do it - is it possible?
i dont know much about that