Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
Month field is coming ok?
yes
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.
Hi,
If you have different date formats, Then I suggest you to use ALT function.
Regards
ASHFAQ
yes right, it's DD//MM//YY. my bad
thanks for your help