MIcrosoft Query - STXT

M

Martin

Hi, I'm in a query in microsoft and I want to separate number. I have some
date in the column name [email protected]. Date look like this : 20090909. I
want only the 4 first digit. I tries those formula but I have a message
saying that the syntax is not valid.

STXT([email protected],1,4)
Gauche([email protected],4)

can someone help me ?
Tks
Martin
 
Top