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)

Martin Dráb 236,907 Most Valuable Professional on at

Like (0)

Report
How to update date field using update_recordset in D365FO

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... 299,960 Super User 2025 Season 2 on at

Like (0)

Report

How to update date field using update_recordset in D365FO

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

Community member 2 on at

Like (0)

Report

How to update date field using update_recordset in D365FO

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

Join the conversation

Community site session details

How to update date field using update_recordset in D365FO

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to update date field using update_recordset in D365FO

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates