8 Replies Latest reply: Jul 5, 2016 12:00 PM by kader kone Branched to a new discussion. RSS

    select possible date when i select another date


      I have one problem.

      so i m 2 dimension calendar



      tempDate AS Date,

      week(tempDate) As week,

      Year(tempDate) As year,

      Month(tempDate) As month,

      MonthName(tempDate) as monthYear,

      Day(tempDate) As day,

      ApplyMap('QuartersMap', month(tempDate), Null()) as quarter

      //Week(weekstart(tempDate)) & '-' & WeekYear(tempDate) as weekYear,

      Resident TempCalendar1

      Order By tempDate ASC;

      Drop Table TempCalendar1;




      TempDate AS Date,

      week(TempDate) As Week,

      Year(TempDate) As Year,

      Month(TempDate) As Month,

      MonthName(TempDate) as MonthYear,

      Day(TempDate) As Day,

      ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

      Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

      WeekDay(TempDate) as WeekDay

      Resident TempCalendar

      Order By TempDate ASC;

      Drop Table TempCalendar;

      when i select date from celandar2, it select the same date to calendar1. I don't want this.

      i want that  i select date from calendar2; it shows me the possible date from calendar1.

      can you help me.thank you