Versions Compared

Old Version 11

changes.mady.by.user Cortlandt _

Saved on

compared with

New Version 12

changes.mady.by.user Cortlandt _

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

Using date-time fields in Load Replace filter settings – Source Field and Target Value or Constant. Use of CONVERT(DATE, GETDATE()) instead of just GETDATE().
Special caution for Sage 100 users.

GETDATE() – Key Points

Example: When run on 2024-03-03 at 10:24:48.168 

T-SQL Expression

DATEADD(DAY,-2,GETDATE())

DATEADD(DAY,-2,CONVERT(DATE, GETDATE())
recommended

returns value

2024-03-01 10:24:48.168

 2024-01-03

data type

datetime

date

Panel
panelIconId2600
panelIcon:sunny:
panelIconText☀️
bgColor#DEEBFF

Unless GETDATE() is executed exactly at midnight the datetime output from GETDATE() is not the same as a date, e.g.;; a date from CONVERT(DATE, GETDATE())

...