Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Helo,
Find qvw attached, how do i split month and day from the field C.Base.
Thanks
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)
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)
Hi Zion
Can you attach your qvw again. I think its corrupted.
Regards
ASHFAQ