Compound IIF Statement


D

DAC

I have a Start Date Field with data like this:
70109
10102
20502
110102
120503
The conversion of this is Month Day Year meaing
70109 = July 1st 2009
10102 = Jan 1st 2002
20502 = Feb 5th 2002
110102 = Nov 1st 2002
120503 = Dec 5th 2003

I would like someones advise on how to write a query to solve this.
 
Ad

Advertisements

K

KARL DEWEY

Try this --
DateSerial("20" & Right([Start Date],2),IIf(Len([Start Date])=6,Left([Start
Date],2),Left([Start Date],1)),Left(Right([Start Date],4),2))
 
Ad

Advertisements

D

DAC

Worked like a charm!!!!!!!!!

KARL DEWEY said:
Try this --
DateSerial("20" & Right([Start Date],2),IIf(Len([Start Date])=6,Left([Start
Date],2),Left([Start Date],1)),Left(Right([Start Date],4),2))

DAC said:
I have a Start Date Field with data like this:
70109
10102
20502
110102
120503
The conversion of this is Month Day Year meaing
70109 = July 1st 2009
10102 = Jan 1st 2002
20502 = Feb 5th 2002
110102 = Nov 1st 2002
120503 = Dec 5th 2003

I would like someones advise on how to write a query to solve this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top