Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format Date with apostrophe

Hello,

I like to get the max(dateofday) from an existing qvd file and use this date in my SQL against the database to get the missing data up to the current date.

To query the database (Teradata) I need the SQL where clause like "  where dateofday > '2012-03-15'  ".

To get the max date from the qvd is no problem, but how can I get the apostrophe around the date value ?

Thanks !

Amigoser

1 Solution

Accepted Solutions
erich_shiino
Partner
Partner

HI, You can try this :

tmpMax:

Load max(dateofday) as MaxDay

from

yourqvd.qvd (qvd);

vMaxDate = text(date( peek('MaxDay'), 'YYYY-MM-DD' );

drop table tmpMax;

sql select * from table where  dateofday > '$(vMaxDate)'

Hope this helps,

Erich

View solution in original post

4 Replies
vupen
Partner
Partner

Please try this:

Let LastFullLoadDate = Date(Peek('LastQVD.LastLoadDate',0,LastQVD),'DD-MMM-YYYY');

Let LastFullLoadDateNum = Num(LastFullLoadDate);

Let vMyDateFilter = ' WHERE MyDateField  between ' & Chr(39) & LastFullLoadDateNum & Chr(39) & ' and sysdate ';

NewData:

Load

*

From

MyTable

$(vMyDateFilter)

;

Not applicable
Author

OK, now I get the following DB error:

ErrorMsg: [Teradata][ODBC Teradata Driver][Teradata Database] A character string failed conversion to a numeric value.

And the SQL looks like :

SELECT ...

FROM "DB"."TABLE"

WHERE dateofday  between '' and DATE

erich_shiino
Partner
Partner

HI, You can try this :

tmpMax:

Load max(dateofday) as MaxDay

from

yourqvd.qvd (qvd);

vMaxDate = text(date( peek('MaxDay'), 'YYYY-MM-DD' );

drop table tmpMax;

sql select * from table where  dateofday > '$(vMaxDate)'

Hope this helps,

Erich

View solution in original post

Not applicable
Author

That's it !

Thanks a lot !