[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
RE: [OT] SQL Query
- Subject: RE: [OT] SQL Query
- From: "Stuart" <lists@xxxxxxxxxxxxxx>
- Date: Fri, 6 Aug 2004 09:48:05 +0100
Thx Steve, I'll give that a go. :-)
Stuart
-----Original Message-----
From: Steve Abbott [mailto:steve.abbott@xxxxxxx]
Sent: 06 August 2004 09:35
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] [OT] SQL Query
Erm, yep
You can use the CVDate function
CVDate(Left(Field,2) & "/" & mid$(Field,3,2) &
"/" & mid$(Field,5,2))
I think my mid$ are wrong there, but the help file will sort you out.
Mid$ is like lefts, it allows you to take a bit out of a string. What I
have done here, is take the dd,mm and year bits out of the string and
recreated a pseudo date using /, and then used the cvdate function to
return a variant of type datetime.
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|