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.
 
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))
 
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.
Click to expand...
Click to expand...
 

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

Similar Threads

Finding 3rd (or 2nd) Sunday in a given year/month 5
Returning a dynamic date range 1
Date Expressions & Calculations 3
Problem with Update Query 5
Nested IIf statement use 4
System Resource Exceeded/Query Too Complex 4
Crosstab Query based on Ordinal Values 6
2 dimensional date sort 1

Top