topic Re: Load Sysdate in Qlikview script in QlikView

Load Sysdate in Qlikview script

anuradhaa — Mon, 02 Mar 2015 07:19:50 GMT

Hi,

I want to use sysdate in my qlikview script.

please help me to do that.

Thanks

anbu1984 — Mon, 02 Mar 2015 07:31:39 GMT

You can use QV function Today() in script

Sql Load sysdate from dual;

prieper — Mon, 02 Mar 2015 07:47:28 GMT

NOW() might fit better, as it returned the time as well:

now([ timer_mode])

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

0 Time at previously finished reload (not currently ongoing reload)
1 Time at function call
2 Time when the document was opened

HTH Peter

er_mohit — Mon, 02 Mar 2015 07:49:14 GMT

Try this in text object

=Date(Today())

Regards

Mohit

anuradhaa — Mon, 02 Mar 2015 08:02:40 GMT

Hi,

I want to use sysdate in data loading. and i have if statement inside the script with other dates.

ex - if(DTM > 0 ,sysdate,DTM) As Date to set DTM=sysdate when date is null

anbu1984 — Mon, 02 Mar 2015 08:07:57 GMT

If(Len(Trim(DTM)) = 0, Today(), DTM)

er_mohit — Mon, 02 Mar 2015 08:11:13 GMT

What you want exactly m confused a bit in above statement

1. If you want sysdate when DTM is null then, try this

If(ISnull(DTM),Date(Today(),'DD-MM-YYYY'),DTM) as Date

Note : please mention above date format as alike your DTM field.

2. If you want sysdate when DTM is greater than 0 as you told earlier in example then, try this

If(DTM>0,Date(Today(),'DD-MM-YYYY'),DTM) as Date

Hope it helps