[Question] How to convert "Last timestamp exported for an updated record" value to datetime ?

Bertverbeek4PS / bc2adls

Exporting data from Dynamics 365 Business Central to Azure data lake storage or MS Fabric lakehouse

MIT License

60 stars 22 forks source link

Closed Isarien closed 7 months ago

Isarien commented 7 months ago

Hello,

I want to display the "Last timestamp exported for an updated record" from "ADLSE Table Last Timestamp" table in a dashboard, but it's seems it's not a correct timestamp format. I read this doc : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-system-fields#timestamp . Can you confirm that it's not real timestamp, but rather a version number

In advance thanks.

Bertverbeek4PS commented 7 months ago

Hi @Isarien indeed that is not a real timestamp value. You can use the last modified date field of a record.

Isarien commented 7 months ago

Thank you for your answer