Rupesh Bhandari

Controlling DateTime Conversion in AL Code

This article explains how to control the conversion of DateTime values from Excel in AL (Application Language) code. It introduces a flag, `ReadDateTimeInUtcDate`, that determines whether the DateTime should be interpreted as UTC or Local time. The article also provides examples of the `ConvertDateTimeDecimalToDateTime` function and how to set the flag to ensure the correct handling of DateTime values during conversion.