web

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

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to filter date in ...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How to filter date in where condition?

(0) Share

Report

Report

Posted on by junior AX

1,552

Hi,

If i want to say in the where condition the following:

Select table1 where table 1 is less than today's date by 2 months

How can i do that? Because each month might have different number of days

Or i shall do today's date - 30 and that's it?

What's the syntax?

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Martin Dráb 237,697 Most Valuable Professional on at

Like (0)

Report

I would utilize DateTimeUtil::addMonths(x, -2).

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Try this,

DateTimeUtil::date (DateTimeUtil::addMonths (DateTimeUtil::newDateTime (asOfDate, 0), -2));

Was this reply helpful? Yes No
junior AX 1,552 on at

Like (0)

Report

Hi Martin,

Is this correct? And would it give me what i'm looking for?

Table.CreatedDateTime < DateTimeUtil::AddMonths(DateTimeUtil:: getToday(DateTimeUtil::getUserPreferredTimeZone()),-2);

Hi Baharani,

I'm not sure why you used newDateTime and what is asOfDate?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Asofdate is the date which is like to provide in range like some date minus 2 months and it will the exact date value as a range. Here asofdate is simply a variable where you should give the date from where you want to go back to 2 months.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 683 Most Valuable Professional

#2

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

#3

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans