Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Dateentered with values 01/01/2011 to 07/08/2014. there is one value 21/08/1899. because of this value the fiscal year is showing values from 1899,1900,1901,1902....2014.
how to write a script to load qvd with out this value.
TblData:
LOAD ID,
name,
Dateentered
SQL SELECT *
FROM tblData
how to change above load statement.
Please can anyone suggest me.
Thanks.
HI,
Try this.
TblData:
LOAD ID,
name,
if(Dateentered= '21/08/1899',null(),Dateentered) as Dateentered
SQL SELECT *
FROM tblData
Regards,
Kaushik Solanki
Hi,
While creation of QVD u have to use some filters and conditions for avoiding the value.
Thanks
TblData:
LOAD ID,
name,
Dateentered
SQL SELECT *
FROM tblData
where Year(Dateentered) not in (1899,1900,1901,1902);
Thanks. I tried it but still showing same years. Is there anyway to change this? Please suggest
HI,
Try this.
TblData:
LOAD ID,
name,
if(Dateentered= '21/08/1899',null(),Dateentered) as Dateentered
SQL SELECT *
FROM tblData
Regards,
Kaushik Solanki
Hi,
Try below
LOAD ID,
name,
Dateentered
SQL SELECT *
FROM tblData
where Year(Dateentered) <>1899;
Regards
ASHFAQ
Hi,
TblData:
LOAD ID,
name,
Dateentered
SQL SELECT *
FROM tblData
where date(Dateentered, 'DD/MM/YYYY') > date('01/01/1900', 'DD/MM/YYYY')
Hope it will help
Augustin
Thanks.