topic adding current date in the table in QlikView

adding current date in the table

Wed, 15 May 2013 06:31:33 GMT

Hello Friends,

As I have a table and I would like to insert a current date field in the table

How to add the today date in the sql select script

Set Date = Today()

SQL

SELECT

Date,

Customer,

Customer_id,

Count(Test) as NumInv,

Sum(Test1) as TotAmt

FROM Scxxx9023;

Regards

Chriss

Re: adding current date in the table

kumarnatarajan — Wed, 15 May 2013 06:35:59 GMT

Hi,

Try This.

SQL

SELECT

Now() as Today,

Date,

Customer,

Customer_id,

Count(Test) as NumInv,

Sum(Test1) as TotAmt

FROM Scxxx9023;

Ex: Now() as Today

Refer Below mentioned URL:

http://www.w3schools.com/sql/sql_dates.asp

Re: adding current date in the table

Wed, 15 May 2013 06:46:48 GMT

Hi Kumar,

Thanks for your help, it works.....

Regards

Chriss