G Guest Feb 27, 2006 #1 i have a value in a tbl - 2006022410503300 how do i convert this to a day of the week ?
T tina Feb 27, 2006 #2 try Format(DateSerial(Left("2006022410503300", 4), Mid("2006022410503300", 5, 2), Mid("2006022410503300", 7, 2)), "dddd") hth
try Format(DateSerial(Left("2006022410503300", 4), Mid("2006022410503300", 5, 2), Mid("2006022410503300", 7, 2)), "dddd") hth
G Guest Feb 27, 2006 #3 There's probably a cleaner solution plus I made some assumption on the data. Format(CDate(Left("2006022410503300",4)& "/" & Mid("2006022410503300",5,2)& "/" & Mid("2006022410503300",7,2)),"DDDD")
There's probably a cleaner solution plus I made some assumption on the data. Format(CDate(Left("2006022410503300",4)& "/" & Mid("2006022410503300",5,2)& "/" & Mid("2006022410503300",7,2)),"DDDD")
