Load Sysdate in Qlikview script

[anuradhaa]

Hi,

I want to use sysdate in my qlikview script.

please help me to do that.

Thanks

[anbu1984]

You can use QV function Today() in script

Or

Sql Load sysdate from dual;

[prieper]

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]

Hi

Try this in text object

=Date(Today())

Regards

Mohit

[anuradhaa]

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]

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

[er_mohit · Accepted solution]

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