web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... ER in d365fo how can I...

Finance | Project Operations, Human Resources, ...

Unanswered

ER in d365fo how can I create condition with filter in model. Different filter in model

(0) Share

Report

Report

Posted on by Lefteris Papadopoulos

43

Hi,

I want to filter the model and to execute it in batch job with dynamic dates.

I created the Calculated fields.

$15_PERMONTH
$16TH_PREVIOUS_MONTH
$FIRSTDATE
$LASTDAY_PREVIOUS_MONTH

I want something like as below. My actions aren't succeded.

IF(TODAY()>'$15_PERMONTH',
FILTER(model.RecordList, AND(
model.RecordList.Date>=model.'1stCurrentDate',
model.RecordList.Date<=model.'15thCurrentMonth'
)
),
FILTER(model.RecordList,
AND(
model.RecordList.Date>model.'15thPreviousDate',
model.RecordList.Date<=model.LastPreviousDate
)
)
)

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 707 Most Valuable Professional

#2

André Arnaud de Cal... 618 Super User 2025 Season 2

#3

CU05031448-0 600

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans