Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks a lot.
It is working now