topic Re: time question in QlikView

time question

Fri, 19 Sep 2014 04:39:55 GMT

hi. im qlikview beginner.

how i get the result (2014-09-11)

today 2014-09-19

how i get this to use script statement.

is it possible using minus --> 2014-09-19

tresB — Fri, 19 Sep 2014 04:42:22 GMT

=Date(Today()-8)

MayilVahanan — Fri, 19 Sep 2014 04:45:09 GMT

Try like this

Load Date(Today()-8 ,'YYYY-MM-DD') as Date autogenerate 1;

engishfaque — Fri, 19 Sep 2014 04:52:35 GMT

Dear Hyunseok,

LOAD Date(Today()-8, 'YYYY-MM-DD') as DateField;

Kind regards,

Ishfaque Ahmed

jagan — Fri, 19 Sep 2014 05:08:56 GMT

Hi,

Try like this

=Date(Today()-8) - 8 is number of days to get 11th.

Regards,

jagan.

varunvarma — Fri, 19 Sep 2014 05:13:20 GMT

Hi,

Try like this

Load Date(Today() - 8,'YYYY-MM-DD') AS Resultdate

AutoGenerate 1;

Regards,

Varun