web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) compare two dates in q...

Microsoft Dynamics AX (Archived)

compare two dates in query

(0) Share

Report

Report

Posted on by Community Member

Hi,

I need to add the following condition in my query :

delete_from Table where Table.useDate + 1month < today

I tried the code below but it's not possible to use expression in where clause :

delete_from Table

where DateTimeUtil::addMonths(Table.useDate,1) < DateTimeUtil::getSystemDateTime;

Best Regard,

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Community Member on at

Like (1)

Report

You can use a while select iteration, get the date,add a month to it,if fits the condition,delete it...

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
1month is not a valid X++ statement. You can either use number of days, or a function for working with months.

You also can't modify the value in database, but you can modify your parameter. Therefore your code can be rewritten to something like this:

delete_from table where table.UseDate < (today - 30);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

it's work Thanks Martin :)

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans