Split values

[Anna]

Hi:
Can any one please tell me how to i separate date from that string.

mdate
yyyy-mm-dd
2006-11-06-09-58-22
2006-11-07-15-34-08
2006-11-08-18-59-01

Thanks.

 

[kingston via AccessMonster.com]

Try:

Left([Field],10)

Hi:
Can any one please tell me how to i separate date from that string.

mdate
yyyy-mm-dd
2006-11-06-09-58-22
2006-11-07-15-34-08
2006-11-08-18-59-01

Thanks.