How to include the DateFilter in the function???

Answers

• Options

  poppins Member Posts: 647

  2012-07-09

  Infact, the function automatically assigns the value of the parameter DateFilter to Period Start so I don't really need to specify that the filter is on Period Start...
  
  I tried to introduce the DateFilter parameter this way:
  

  GenerateMatrixData(SetWanted,MaximumSetLength,UseNameForCaption,PeriodType,'>=DMY2DATE(1,1,(DATE2DWY(TODAY,3)-1))',PKFirstRedInCurrSet,CaptionSet,CaptionRange,CurrSetLength,PeriodRecords)
  

  
  but I got the following error message:

  Overflow under type conversion of text to text
  Value: DMY2DATE(1,1,(DATE2DWY(TODAY,3)-1))
  

  
  What should I do???

  0
• Options

  Chinmoy Member Posts: 359

  2012-07-09

  Put the value in a date variable
  
  TempDate := DMY2DATE(1,1,(DATE2DWY(TODAY,3)-1));
  
  then pass
  
  '>=FORMAT(TempDate)'
  
  This shud work..
  
  Chn

  0
• Options

  poppins Member Posts: 647

  2012-07-09

  Chinmoy wrote:

  Put the value in a date variable
  
  TempDate := DMY2DATE(1,1,(DATE2DWY(TODAY,3)-1));
  
  then pass
  
  '>=FORMAT(TempDate)'
  
  This shud work..
  
  Chn

  
  Actually, it didn't work
  
  I even tried :

  TextDate := '>=FORMAT(TempDate)';
  

  where TextDate is a variable of type Text and then passed it to the function....
  
  The result is the following error:

  '>=FORMAT(TempDate)' is not a valid date...
  

  
  What can I do???

  0
• Options

  poppins Member Posts: 647

  2012-07-09

  I finally did it....That's how I proceeded:

  TempDate := DMY2DATE(1,1,(DATE2DWY(TODAY,3)-1));
  TextDate := FORMAT(TempDate);
  
  DateFilter := '>= '+TextDate;
  

  
  And I passed DateFilter to the function....It works
  
  Thank you Chinmoy, you've been of a great help

  0
• Options

  Chinmoy Member Posts: 359

  2012-07-09

  You are welcome...
  
  please mark the post as solved.
  
  Chn

  0