Finance | Project Operations, Human Resources, ...

How to update date field using update_recordset in D365FO

(0) Share

Report

Posted on by CU21091228-0

230

Hi Team,

Using update_recordset i am updating the date.

Below code i am using.

public static void postGetStagingData(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution)    {        TestStaging    testStaging;               update_recordset testStaging            setting RequestedDeliveryDate = str2Date(subStr(testStaging.DateConvert, 1, 2) + '-' + subStr(testStaging.DateConvert, 3, 2) + '-' + subStr(testStaging.DateConvert, 5, 2), 321)                where testStaging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId &&                      testStaging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup;    }

testStaging.DateConvert = '230314';

But in testStaging.DateConvert is sowing null value.

If i use select statement and update the RequestedDeliveryDate, i can able to update.

Please let me know how to update RequestedDeliveryDate using update_recordset.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 240,163 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Let me re-post your code.
public static void postGetStagingData(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution) { TestStaging testStaging; update_recordset testStaging setting RequestedDeliveryDate = str2Date(subStr(testStaging.DateConvert, 1, 2) + '-' + subStr(testStaging.DateConvert, 3, 2) + '-' + subStr(testStaging.DateConvert, 5, 2), 321) where testStaging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId && testStaging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup; }

I don't think that F&O is able to translate all the X++ functions (such as str2Date()) to T-SQL, so I indeed wouldn't expect it to work.

Can't you parse the DateConvert value inside your entity?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,430 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Reading the coding you shared is hard as the format lost the new lines. Anyway, you try to use the update_recordset calculating a field with values from the original records. I don't think the update_recordset will be feasible here. The generated SQL will literally replace the current known values. As the testStaging record in your coding is empty, it will use empty values to update using this command.

It would be possible if you have a fixed date to update on several records.

Was this reply helpful? Yes No
Suggested answer

CU27040919-18 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

update_recordset cannot use X++ methods. It does not translate them into the SQL ones, but calculates them immediately on the moment of start (once).

to solve your task, you will have to code it as

while select testStaging

{

// do your conversion logic

testStaging.update();

}

Was this reply helpful? Yes No