Skip to main content
Solved

Quick Report, parameters, date range


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

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1481 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))


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

It works. Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings