web

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

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 236,907 Most Valuable Professional on at

Like (0)

Report

RE: How to filter date in where condition?

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

RE: How to filter date in where condition?

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

RE: How to filter date in where condition?

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

RE: How to filter date in where condition?

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

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

#2

CA Neeraj Kumar 588

#3

Martin Dráb 542 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans