Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time question

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

5 Replies
tresesco
MVP
MVP

=Date(Today()-8)

MayilVahanan

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
engishfaque
Specialist III
Specialist III

Dear Hyunseok,

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

Kind regards,

Ishfaque Ahmed

jagan
Partner - Champion III
Partner - Champion III

Hi,


Try like this


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


Regards,

jagan.

varunvarma
Contributor III
Contributor III

Hi,

Try like this

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

AutoGenerate 1;

Regards,

Varun