Hello I'm new in here, i want ask for to filterdate

Answers

• Options

  ThomasHagenmeyer Member Posts: 14

  2023-07-21 Answer ✓

  Hi GustingurahW,
  
  welcome to the forum. Please post your code that sets the filter, including the calculation of the minimum and the maximum date of your range.
  
  Best Regards,
  Thomas

  0
• Options

  GustingurahW Member Posts: 11

  2023-07-21

  Hai Thomas Thankyou for the answer, this is my code about the sets filter and the calculation
  trigger OnPreDataItem()
  var
  DateFilter: Record "Item Import CSV";
  StartDate: Date;
  EndDate: Date;
  begin
  // StartDate := CalcDate('<-CM>', Today);
  // EndDate := CalcDate('<CM>', Today);
  // DateFilter.SetRange("Posting Date", StartDate);
  DateFilter.SetFilter("Posting Date", 'MONTH');
  Message(DateFilter.GetFilter("Posting Date"));
  end;

  0
• Options

  ThomasHagenmeyer Member Posts: 14

  2023-07-21 Answer ✓

  Hi GustingurahW,
  
  You nearly got there already: CM means Current Month, <-CM> yields the first day of the current month, <CM> the last day of the current month. If you want to get the dates for the last month, I'd say:
  
  StartDate := CalcDate('<-CM-1M>', Today);
  
  The last day not always is the same , so <CM-1M> won't do the trick. But, the last day of the previous month ist just one day before the first day of the current month, therefore:
  
  EndDate := CalcDate('<-CM-1D>', Today);
  
  and then:
  
  DateFilter.SetRange("Posting Date", StartDate, EndDate);
  
  Best Regards,
  Thomas

  0
• Options

  GustingurahW Member Posts: 11

  2023-07-21

  Hi ThomasHagenmeyer,
  
  Thankyou for the answer,
  
  may i ask you again?
  i use the code in the pageextension is working, but why i use in create report is not working?
  

  0
• Options

  GustingurahW Member Posts: 11

  2023-07-21

  i want filter the data report using filter date to show the data, but if i try this code in the report is not working, filter give me a data until the current month

  0
• Options

  vaprog Member Posts: 1,118

  2023-07-24

  Hi GustingurahW
  
  Again, you did not provide your relevant code. The code works identically on a Page and on a Report, assuming you set the filter on a field of type Date in each object.
  
  Please use Code-tags for posting your code. It makes it easyer to read, especially if the code is indented.
  
  Above you used

  DateFilter.SetFilter("Posting Date", 'MONTH');
  

  Please note that this is not a valid filter expression for a Date field. In the client filter text given by the user is translated, before it is used as a filter expression. This translation happens in Codeunit 41 Textmanagement. In code you need to call those functions yourself, or more commonly, use the resulting proper filter expression directly, or using SETRANGE with the proper boundaries calculated using CALCDATE as suggested here.
  
  I recommand you familiarize yourself with DateFormula expressions by exercise, trying to calculate different DateFormula expressions on different dates.

  0
• Options

  GustingurahW Member Posts: 11

  2023-07-25

  Hi Vaprog,
  Thankyou For the answer
  
  about my problem is fixed, i forget type the tag for to my report,, once again i said thanyou so much
  
  Best Regards,
  GustingurahW

  0