Solved: Date Variables in input box - Qlik Community

vikasmahajan · ‎2016-04-14

I have Variable v_Date 31-01-2015 & I want to show v_Date1 as (v_date-30 days)

in input box .

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sunny_talwar · ‎2016-04-14

Try this:

=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')

View solution in original post

sunny_talwar · ‎2016-04-14

Try this:

=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')

sunny_talwar · ‎2016-04-14

Or this for 30 days:

=Date(Date#(v_Date, 'DD-MM-YYYY') - 30,'DD-MM-YYYY')

vikasmahajan · ‎2016-04-14

thnx

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Date Variables in input box

Related Topics