How do i split date from one listbox into 3 day, month and yr

[Anonymous]

Helo,

Find qvw attached, how do i split month and day from the field C.Base.

Thanks

[avinashelite]

Hi Zion,

I am not able to open your document.

You can achieve this in Script or in the front end.

Script:

load filedC,

year(fieldC) as Year_fieldC,

monthname(fieldC) as month_fieldC,

dayname(fieldC) as Day_fieldC

sql select *

from..

In front end you can directly use the year(fieldC) , Monthname(fieldC), dayname((fieldC)

[#3]

Hi Zion,

Since your file is not getting opened I cannot see your table n field. But u can try these functions:

year(DateField)

month(DateField)

day(DateField)

[ashfaq_haseeb]

Hi Zion

Can you attach your qvw again. I think its corrupted.

Regards

ASHFAQ