Convert number to date

[douggy]

Hi there,

I have to convert the following number format to a date. ie something I can query on for where a year month between x and y.

Number is in following format "200801" YYYYMM

Thanks for your help in advance.

Mark

 

[SkipVought]

hi,

EndOfMoDte: DateSerial(Mid("200801",1,4),Mid("200801",4,2)+1,0)
StrtOfMoDte: DateSerial(Mid("200801",1,4),Mid("200801",4,2),1)

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}