Date Problem

[#1]

Hi guys,

I am working from a csv file and I have a field that I want to use as a date.

I have tried about everything to make it display correctly as MMM-YYYY but it displays wrong always. I have used date, date# and other functions. It comes up with a date that does not exist yet Aug-2450. I have also attached the file I am loading from.

Please I need help a.s.a.p to continue my development as it should display as May-2011 or Apr-2011.

Thanks

[m_woolf · Accepted solution]

The YEAR_MONTH field has data is this format: 201105

When reading the data, you could try something like this:

Makedate(left(YEAR_MONTH,4),right(YEAR_MONTH,2),1) as YEAR_MONTH

[#3]

Thanks a lot.

It is working now