web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Set Validto field to M...

Microsoft Dynamics AX (Archived)

Set Validto field to MaxDate

(0) Share

Report

Report

Posted on by Community Member

I am trying to set Max Data on PurchLineHistory, but it didn't work, kindly help to see what is the error (Dynamic AX 2012 R2 CU7)

void job2 ()

{

PurchLineHistory plh;

;

while select forupdate plh where plh.PurchId=="ABC-000123"

{

if(plh)

{

ttsbegin;

plh.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);

plh.ValidTo = DateTimeUtil::maxValue();

plh.update();

ttscommit;

}

}

}

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

seems , select statement is not bringing any data, because you have not specified any validTimeState in your statement? give a try by specifiying dateTime in outside while loop

while select forUpdate validTimeState(fromDateTime, toDateTime) PurchLineHistory

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Something like this?

its telling me operand type are not compatible with the operator (line9)

void job2 ()

{

PurchLineHistory plh;

FromDateTime aDate;

toDateTime bDate;

;

aDate = 1\1\2014;

bDate = 31\12\2016;

while select forupdate validTimeState(fromDateTime, toDateTime) plh where plh.PurchId=="ABC-000123"

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

DateTime means Date+Time, not only Date.

something as below.

utcdatetime minDateTime = DateTimeUtil::utcNow();

utcdatetime currentDateTime = DateTimeUtil::utcNow();

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