Date converting

[Rzadziu]

Hello,

Im trying to convert this 20071105 in to this 05.11.2007 directly in query unfortunately without good resoult.
I have try to do this also in raport by using =DateSerial(Left([EXP];4);Mid([EXP];5;2);Right([EXP];2)) but when field EXP is zero i got an error.

It is possible to convert it in some other way.

BR Marcin

[June7]

The semi-colon works?

What date do you want to show if EXP has 0?

DateSerial(Left(IIf([EXP]=0,"00000000",[EXP]),4),Mid(IIf([EXP]=0,"00000000",[EXP]),5,2),Right(IIf([EXP]=0,"00000000",[EXP]),2))

[Rzadziu]

Hello June7,

Thanks for your quick reply,

When EXP is 0 then on Report it should not be visible.

[June7]

Calculate the date conversion in query. Force the date to be some impossible value, like 1/1/1900. Use 19000101 in place of 00000000.

Then another calculation in query references the converted date field or in textbox: IIf([fieldname]=1/1/1900, Null, [fieldname])

[Rzadziu]

Thanks June7

Problem solved