Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Morinello]

OK, this should be simple (for Dexterity 18.00.0015.000) but I can’t find a solution.
I am writing a Dexterity project in-house that updates Sales POs after the fact, and have a requirement for an Audit table to track changes. 

I have the table creating ok, but need to record the datetime for the local computer date & time. Dex_Row_TS won’t do because of project requirements.

I do not see an option for a datetime data type. I tried like this below, and can only update the date portion of the field in Dexterity code.
      ‘Changed_Date’    of table ASCEND_POCHANGE_AUDIT =  sysdate(); 

I see no datatime Data Type

How do I go about creating this custom table with a datetime field, and update it in dexterity with the local date & time of record creation?

——————————
David Morinello
Senior Dynamics GP Systems Architect
Ascend Learning, LLC
Leawood KS
——————————

[David Musgrave]

Hi David

Dexterity uses Date and Time as separate fields. In SQL they are stored as datetime with no time and datetime with fixed date, but in Dexterity you need to use separate fields.

There is support for a datetime datatype, but that is primarily for passing to .Net code.

You can use sysdate() and systime() or if you want to sync with the SQL Server you can use sysdate(CURRENT_SERVER) and systime(CURRENT_SERVER).

Hope this helps.

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-