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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
MVP
MVP
‎2016-04-14 05:08 AM

Date Variables in input box

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.
Labels (1)
Labels
Date Test.qvw
2,534 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2016-04-14 05:10 AM

Try this:

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

View solution in original post

Date Test.qvw
2,174 Views
3 Replies
sunny_talwar
MVP
MVP
‎2016-04-14 05:10 AM

Try this:

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

Date Test.qvw
2,175 Views
sunny_talwar
MVP
MVP
‎2016-04-14 05:12 AM

In response to sunny_talwar

Or this for 30 days:

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

2,174 Views
0 Likes
vikasmahajan
MVP
MVP
‎2016-04-14 05:13 AM
Author

In response to sunny_talwar

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.
2,174 Views
0 Likes