create date question

[#1]

hi

load ......

     belegpos.date,

     year(belegpos.date) as year,

     month(belegpos.date) as month,

     day(belegpos.date) as day,

     .......

from belegpos.qvd;

now when put a lsitbox where i should see the years or months or days there is no data. why???

belegpos.date is in the qvd like: 15/04/11 (MM/DD/YY)

thanks

[tresesco · Accepted solution]

Use parsing function date#() like:

load ......

     belegpos.date,

     Date(Date#(belegpos.date, 'MM/DD/YY')) as Date,

     year(Date#(belegpos.date, 'MM/DD/YY')) as year,

     month(Date#(belegpos.date, 'MM/DD/YY')) as month,

     day(Date#(belegpos.date, 'MM/DD/YY')) as day,

     .......

from belegpos.qvd

[#3]

hey

it seems that there are only the first 12 days of the month.

listbox:

day 1

     2

     3

     4

......

     12

end.

do you have an idea why?

[tresesco]

Month field is coming ok?

[#5]

yes

[tresesco]

Then, perhaps the data is so. Wait, i guess it should be 'DD/MM/YY' rather than 'MM/DD/YY'. Change the format code in date#() and try.

[ashfaq_haseeb]

Hi,

If you have different date formats, Then I suggest you to use ALT function.

Regards

ASHFAQ

[#8]

yes right, it's DD//MM//YY. my bad

thanks for your help