Help required in adding offset of 10 days to my datefield

[rajtechnocraft]

Hi Experts, I am facing issue with date format I tried using date #,makedate and other functions but am not able to add offset of 10 days to my date field RFS_DATE ex if this is date 10-07-2013 then i want to add offset of 10 days so the result would be 20-07-2013 Attached is the qvw. Regards Raj

[#2]

Hello Raj,

your DATE field is in string format only.

That ´s the reason you can´t do some calculations with it.

Change your load script so that QV is able to interpret your DATE field

as a number.

If you load your data you can use a statement like this:

Date(Date#(RFS_DATE,'YYYY-MM-DD'),'YYYY-MM-DD') as RFS_DATE; 

DATE# is used for interpretation of a given string.

DATE is used to get the format we want to have.

See the attached example for the syntax.

Good luck!

Rainer

[#3]

TRY THIS

=date(DATE#('10-07-2013','DD-MM-YYYY') +10,'DD-MM-YYYY')

OR TRY THIS

=date(DATE#(RFS_DATE,'DD-MM-YYYY') +10,'DD-MM-YYYY')

[er_mohit]

TRY THIS IN TEXT OBJECT

=DATE(DATE(Today())+10,'DD-MM-YYYY')

[#5]

Raj,

please see also the document written by Henric Cronström:

     http://community.qlik.com/docs/DOC-2811

Rainer

[anandathome]

See if the attached helps

[#7]

hi RajTechnocraft

if your problem resolved then marked it as either correct or helpful according to your question, and close this thread, so that it might be helpful for other developer.

Regards

vishwaranjan

[#8]

DATE(Day(Today())+10,'DD-MM-YYYY')