how to add days to yyyymmdd format

[Anonymous]

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

[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')

[mightyqlikers]

Hi

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

$@M.

[susovan]

Hi Stefan,

Try this,

Date(DateField,'YYYYMMDD')

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