Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a Sql table like below here p.todate in dd/mm/yyyy hh:mm:ss format.
from this p.todate field how to derive the Quarteryear and WeekYear fields in below format in Sql syntax only.
Please help me on this.
Sql Select
p.id
p.product,
p.todate
From products p;
Thanks in advance
if you are running in qlikview then you can extract table from sql database then do operations on extracted table using qlikview script functions.