Small and medium business | Business Central, N...

How to date range in Business Central

(0) Share

Report

Posted on by Dividutt

200

I have two fields DatecreateTo and DatecreateFrom which is getting from systemcreatedat so when I need range between yesterday and today it's showing only for today, ?

Please is there any solution how we can do,

I used setfilter on both fields and passed the variable to it which I globally defined., And hence called.

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to date range in Business Central

Hi,

I'm not sure if your code meets your requirements, but it seems that you have defined the same field (recEnquiries.DateCreated) twice, which could be causing the issue you are facing. Try adding recEnquiries.DateCreatedTo instead.. like this

varFilterPageBuilder.AddField('Enquiries', recEnquiries.DateCreated);

varFilterPageBuilder.AddField('Enquiries', recEnquiries.DateCreatedTo);

Regards
Dividutt 200 on at

Like (0)

Report

RE: How to date range in Business Central

This is code:

action("Open Enquiries Filter Page")

{

Caption = 'Open Enquiries Filter Page';

ApplicationArea = All;

Promoted = true;

PromotedCategory = Process;

PromotedIsBig = true;

trigger OnAction()

var

varFilterPageBuilder: FilterPageBuilder;

Enquiries: Record Enquiries;

FilterExpr: text;

recEnquiries: Record Enquiries;

Past3Months: Date;

varDefaultView: Text;

varDateItem: Text[30];

cdu_FilterTokens: Codeunit "Filter Tokens";

begin

Enquiries.Reset();

varFilterPageBuilder.AddTable('Enquiries', Database::Enquiries);

varFilterPageBuilder.AddField('Enquiries', Rec.No);

varFilterPageBuilder.AddField('Enquiries', Rec.Status);

varFilterPageBuilder.AddField('Enquiries', Rec.Email);

varFilterPageBuilder.AddField('Enquiries', Rec.Contact);

varFilterPageBuilder.AddField('Enquiries', recEnquiries.DateCreated);

varFilterPageBuilder.AddField('Enquiries', recEnquiries.DateCreated);

varFilterPageBuilder.PageCaption := 'Enquiries Filter Page';

if varFilterPageBuilder.RunModal() then begin

Enquiries.SetFilter(DateCreated, DateCreate);

Enquiries.SetFilter(DateCreatedTo, DateCreateTo);

if Enquiries.FindSet() then begin

Enquiries.SetView(varFilterPageBuilder.GetView('Enquiries'));

CurrPage.SetTableView(Enquiries);

end;

end;

end;

}

}

}

var

DateCreate: Text;

DateCreateTo: Text;

}