Calendar - fromDate and toDate

[#1]

Hi,

My calendar script is loading fine but the table not reflecting any changes. Below the code i am using

Calendar:

load Distinct

"sDate",

  Year("sShipment Date") As PostingYear,

  Month("sShipment Date") As PostingMonth,

  Week("sShipment Date") As PostingWeekOnly,

  WeekDay("sShipment Date") As PostingWeekDay,

  Day("sShipment Date") As PostingDay,

  'Q' & Ceil(Month("sShipment Date")/3) As PostingQuarter

resident myTable;

Temp:

Load

  min("sDate") as minDate,

max("sDate") as maxDate

Resident Calendar;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

I create calendar object but when I pick the date I don't see change in my straight table.

I want when change start and end date to get result in my table between start and end date. Does anyone have an idea?

[settu_periasamy]

Where do you want to get the result of between the dates? if you are using variable for the calendar object, you need put the variable inside of the Expression (I guess you are using Straight or Pivot chart). like

=sum({<sDate={">=$(varMinDate)<=$(varMaxDate)"}>}Sales)

[inescastelhano]

Can you post the expression of your straight table?

[Gysbert_Wassenaar · Accepted solution]

Perhaps this video tutorial helps: Selecting Arbitrary Date Ranges

[#5]

Thanks Gysbert, that's it...