topic Re: Create Variable with Date and Time in QlikView

Create Variable with Date and Time

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following variable:

LET vYEAR = YEAR(TODAY())-3; // vYEAR = 2014

What I need is to create 2 more variables with the following values:

vSTART = 20150701 06:00:00 hs // 1st day of july at 6 am from vYEAR+1

vEND = 20171001 06:00:00 hs // 1st day of current month at 6 am from current year

(*) Date format: YYYYMMDD hh:mm:ss

Do you know how could I get those values to use them in variables?

Thank you!

Re: Create Variable with Date and Time

oscar_ortiz — Wed, 11 Oct 2017 16:05:39 GMT

Maybe something like this:

LET vStart = Date( YearStart( MakeDate(2014) ) , 'YYYYMMDD') & ' 06:00:00 hs'

LET vEnd = Date( MonthStart( today() ), 'YYYYMMDD' ) & ' 06:00:00 hs'

Good luck

Oscar

Re: Create Variable with Date and Time

oscar_ortiz — Wed, 11 Oct 2017 16:10:50 GMT

LET vStart = Date( YearStart( MakeDate(2014) ) , 'YYYYMMDD') & ' ' & MakeTime( 6,0,0 )

LET vEnd = Date( MonthStart( today() ), 'YYYYMMDD' ) & ' ' & MakeTime( 6,0,0 )

Thanks

Oscar

Re: Create Variable with Date and Time

antoniotiman — Wed, 11 Oct 2017 16:14:09 GMT

May be this

SET DateFormat='YYYYMMDD';
SET TimestampFormat='YYYYMMDD hh:mm:ss[.fff]';
LET vSTART = TimeStamp('20150701 06:00:00')&' hs';
LET vEND = Timestamp(MonthStart(Today())&' '&'06:00:00')&' hs';

Re: Create Variable with Date and Time

maxgro — Wed, 11 Oct 2017 16:16:49 GMT

another one

LET vYEAR = YEAR(TODAY())-3; // vYEAR = 2014

LET vSTART = Date(Makedate(vYEAR+1, 7) + 6/24, 'YYYYMMDD hh:mm:ss');

LET vEND = Date(MonthStart(Today()) + 6/24, 'YYYYMMDD hh:mm:ss');