I need to display data for 24 hours of duration using a user date. For this I need to add 1 day to the input date value.
Select Name, Amt, Trns_Date from Table1
Trns_Date between Date_Prompt1 and (Date_Prompt1+1)
Any help will highly be appreciated.
Thanks in advance,
Marrish (BOB member since 2019-08-12)