Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calender Objects

How to write a Let function for sales date range in edit script?

3 Replies
avinashelite

Hi Vamsi,

Can you please elaborate your problem.

Not applicable
Author

Hi Avinash,

I need syntax for vFromDate= and vToDate= ...for calender object .

I want to select date specific for my sales data.

israrkhan
Specialist II
Specialist II

you can try like,

let vFromDate = Today() - 40; it will give you 40 days back date.

let VTodate = Today() - 2; it will give you 2 days back, as 27- 07- 2014

or let vtoday = Today(); will give you tday...

and than in the textbox you can use as, =Date(VTodate) and = date(vFromDate )  to see whats dates coming...

Hope it help...