Discussion Board for collaboration on QlikView Scripting.
I want to show date time stamp like 'YYYYMMDDhhmm' but while doing in the qlikview my expression is returning :
Output : 201509030000
but in hour and minute i want the value not 00 .
As per QV Help. you can use Timestamp#
timestamp#( A, 'YYYY-MM-DD hh_mm' ) where A=8/6/97 09_00 returns:
I hope this helps you.
today() instead now delivers 2015090309
replace today() date
with now() timestamp
Returns the current date from the system clock. The timer_mode may have the following values:
0 Date at script run1 Date at function call2 Date when the document was opened
Default timer_mode is 2. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.
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 call2 Time when the document was opened
Default timer_mode is 1. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.
Please use like this:
Load *, Timestamp(Today()) as NewDate;
LOAD timestamp(Start_time) as Start_time,timestamp(end_time) as end_time Inline [
Hi Vir, Did you able to get the solution?
Use below expression
Hope this helps you.
Hi Did you able to manage to get the answer?