Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 29 Dec 2008 at 6:20am
If you just want to select the month portion of the string, I would use LEFT({datafield}, 2). If you want use it as a number, VAL(...) will convert the string to a number value.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
