Versions Compared

Old Version 54

changes.mady.by.user Dean Marriott

Saved on

compared with

New Version 55

changes.mady.by.user Dean Marriott

Saved on

Key

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

...

Run with a user form and parameters
replaceCTPEffectiveDateEffDate::EffDateEffective Date:select::July 2021-07-01:2021-07-01:April 2021-07-01:2021-04-01::

ITCE 12 Month Rates

No Records Found!trueS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"true100%style="background:#f2f2f2;text-align:center;font-weight:bold",,,,ManufacturerDSBLOCKINLINE



SQL
heading0
dataSourceManufacturerDS
tablefalse
select 'CTP Rates Effective From: ' + CONVERT(VARCHAR,MAX(eff_date),103) FROM [ManufacturerDataCentre].[dbo].[CTP_qld_import]

...