?
Solved

Dynamics AX 2009 - Programming Example

Posted on 2009-04-06
3
Medium Priority
?
1,095 Views
Last Modified: 2012-05-11
Dear Experts,

In AX 2009 can someone please assist me with the following code example:

Table1
-------------
Id
Description
BeginDate
EndDate

Basically I need to run an update query that will find rows where id = x and EndDate = <empty> then update the row and insert EndDate = Date - 1 day.

What I am struggling with is date time methods in X++.
1. How can you subtract 1 day from a datetime value????
2. Query to update all rows where Id = X and EndDate = <empty>, how will this where clause looks like?


Please help ASAP.
Kind regards.
0
Comment
Question by:Marius0188
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
Agrippine earned 2000 total points
ID: 24084655
Hi again ;-)

to check for an empty date, use the method datenull().
To set a field to date - 1, just write "systemdateget() - 1" ...

I hope the example helps.

Kind regards!

static void Job1(Args _args)
{
    InventTableModule   inventTableModule;
    ItemId              itemId = 'ESB-007';
    ;
 
    ttsbegin;
 
    while select forupdate inventTableModule
        where   inventTableModule.ItemId    == itemId
            &&  inventTableModule.PriceDate == datenull()
    {
        inventTableModule.PriceDate = systemdateget() - 1;
        inventTableModule.update();
    }
 
    ttscommit;
}

Open in new window

0
 

Author Comment

by:Marius0188
ID: 24085034
Just another question.
Let say you instead of using systedateget() you would like to use the date field from a row?

Would you simple - 1 as well to get the day before?


Thanks for the quick reply....
0
 
LVL 5

Expert Comment

by:Agrippine
ID: 24085205
Yes, I would
inventTableModule.PriceDate = inventTableModule.PriceDate - 1;

Open in new window

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question