Date Format while Exporting Objects as Text From NAV/BC14 Database

 Please keep an eye on your System's Date Format (Control Panel/ Regional Settings), while exporting objects from NAV database as text for compare/merge while doing upgrade work, because Date Format setting will change code in your exported objects as well, if explicit date is used in the code; for example if a NAV Object is exported from a System where date format is MM-DD-YYYY and it has a code like this

    If PostingDate>12319999D then etc.

in a System, where date format    YYYY-MM-DD, it will be exported as 

  If PostingDate>99991231D then etc.

And if you compare (Compare-NavApplicationObjects), this 2 same objects, you will find that a DELTA file being created from the comparison, which is misleading and wrong. So, be careful about the System's Date Format, while exporing NAV Objects for Comparison/Merge/Upgrade: ORIGINAL, MODIFIED, TARGET Files should be exported with the same System Date Format.