Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have a dates to variables question. I have date Dimension field called History_Date in the format of DD/MM/YYYY. I want to create 2 variables History_Date_From and History_Date_To, so that a end user makes a selection of 2 dates, then the chart should calculate the sum(sales). Earlier I have done something similar using AutoGenerate function for just weeks... but here its a full date format, so a bit confused as to how to do it.
Any suggestions are welcom and Thanks in advance
Mady
Hi again.
Usually when I want to do this, I create a button with a series of actions:
- 1. Clear all or clear certain fields
- 2. set variable vFromDate = (blank)
- 3. set variable vToDate = (blank)
- 4. some other action