Date selection- from and to date

[#1]

Hi All,

I have a date column TransDate.

How can I created FromDate and Todate from TransDate?

Thanks in advance.

[arulsettu]

try this

FromDate = min(TransDate)

Todate = max(TransDate)

[Anonymous]

You need to load two more data island columns in your script other wise once you will do selection in TransDate it assign same value in FromDate and ToDate.

so do a resident load from the table where TransDate column is loaded

load

distinct (TransDate) as   FromDate

resident table(abc);

Load

distinct (TransDate) as   ToDate

resident table(abc);

Then use these fields for selection (calender/Slider) and store the value into variables

and use those variables in your expression.

Hope this help!!

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.