Compound IIF Statement

  • Thread starter Thread starter DAC
  • Start date Start date
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.
 
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))
 
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.
Click to expand...
Click to expand...
 
Back
Top