topic get current date in QlikView

date manipulation

Tue, 17 Nov 2009 12:04:26 GMT

Is there any variable or function in QlikView that returns the current system date,time?

Then id like to subtract the current date with a give date and return the number of days.

Any idea on how this can be done?

get current date

Anonymous — Tue, 17 Nov 2009 12:10:38 GMT

Sure. Try now() or localtime(). Keep in mind that they poll the system every second for the time though.

You might want to do now(2) to pull the time when the document was opened.

get current date

Tue, 17 Nov 2009 12:19:36 GMT

thank you. i've just edited the post. can you answer my second question too?

get current date

Anonymous — Tue, 17 Nov 2009 12:28:23 GMT

If you only want the number of days you can use:

=today() - YourDate

This assumes that you've provided your date in a date formatted way, the way specified in the script under DateFormat.

If you want to enter a date into a variable you can use:

=Today() - $(VariableName)

If your date contains a time section too the result will have a decimal part indicating the time of the day. This can be removed by using the floor() function around the expression:

=Floor(Today() - $(VariableName))