Skip to main content
Solved

Quick Report, parameters, date range

  • April 7, 2022
  • 2 replies
  • 754 views
J
Do Gooder (Customer)
Forum|alt.badge.img+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

Best answer by ShawnBerk

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))

2 replies

S
Superhero (Customer)
Forum|alt.badge.img+28
  • ShawnBerk
  • Superhero (Customer)
  • 1482 replies
  • Answer
  • April 7, 2022

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))

J
Do Gooder (Customer)
Forum|alt.badge.img+7
  • jaylee78
  • Author
  • Do Gooder (Customer)
  • 15 replies
  • April 8, 2022

It works. Thanks!


Terms & ConditionsCookie settingsAccessibility statement