RE: [OT] SQL Query

["Steve Abbott" <steve.abbott@xxxxxxxxxxxxx>]

Msgbox(Left(youfieldname,8))

Or

dim x as string
Dim y as string

Y = "20040804125000"

X = left(y,8)


There you go.

Steve


-----Original Message-----
From: Stuart [mailto:lists@xxxxxxx]
Sent: 06 August 2004 07:48
To: ukha_d@xxxxxxx
Subject: [ukha_d] [OT] SQL Query

Hello SQL Gurus ;-)


I have a field in an access database that is (like) 20040804125000.

Clearly this is year/month/day/hour/minute/second.

What can I put to only get the first 8 characters (ie date only)

Thx in advance

Stuart


[Non-text portions of this message have been removed]