Solved

Quick Report, parameters, date range

  • 8 April 2022
  • 2 replies
  • 469 views

Userlevel 3
Badge +7

Hi,

 

I’d like to put a date range for my SQL statement. Could you please advise?

 

SELECT 
payment_address.Identity,
SUPPLIER_INFO_GENERAL.Name,
payment_address.Party_Type,
payment_address.Way_ID,
supplier_info_general.creation_date,
payment_address.Description,
payment_address.Default_Address,
payment_address.Data1,
payment_address.Account


FROM   payment_address
FULL JOIN SUPPLIER_INFO_GENERAL
ON payment_address.IDENTITY = SUPPLIER_INFO_GENERAL.SUPPLIER_ID

icon

Best answer by ShawnBerk 8 April 2022, 01:20

View original

2 replies

Userlevel 7
Badge +28

It will usually be something like this….

 

and date_applied between to_date('&[-C-BL]Start_Date_Range', 'YYYYMMDD') and
       to_date('&[-C-BL]End_Date_Range', 'YYYYMMDD') + (1 - 1 / (60 * 60 * 24))

Userlevel 3
Badge +7

It works. Thanks!

Reply