Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
s33pie007
Creator
Creator

how to add days to yyyymmdd format

Hi everyone,

I have the following date column in the format: yyyymmdd, eg. 20160630.

I wish to add 7 days to this column, so the new data must then be 20160707.

I tried using interval, as well as just +7, but no luck.

help will be appreciated.

regards,
Stefan

3 Replies
Gysbert_Wassenaar

Turn it into a date first: date#(MyDate,'YYYYMMDD') as MyDate. Then you can add 7 to a MyDate value and get the correct date a week later back. Try it out in a textbox: Date(Date#(20160630,'YYYYMMDD')+7,'YYYYMMDD')


talk is cheap, supply exceeds demand
mightyqlikers
Creator III
Creator III

Hi

=date(date(date#('20160630','YYYYMMDD'),'DD-MM-YYYY')+7,'YYYYMMDD')

$@M.

susovan
Partner
Partner

Hi Stefan,

Try this,

Date(DateField,'YYYYMMDD')

Date(Date(DateField,'YYYYMMDD')+7,'YYYYMMDD')

Warm Regards,
Susovan