truncating data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I import data from an excell file into a table. The date field comes in as
1070807 (1,yy,mm,dd). I want to just us the last 6 digits or places. Can
make the field text or number.
 
Right(Trim([YourField]),6) should do it.
I import data from an excell file into a table. The date field comes in as
1070807 (1,yy,mm,dd). I want to just us the last 6 digits or places. Can
make the field text or number.
Click to expand...
 
Back
Top