I have a Sybase DB and I have a Query that has the following:
DATEFORMAT(CALENDAR_DATE, 'MM/DD/YYYY') AS CALENDAR_DATE_STR
The user will input a date at a command prompt like
01/01/2011 or 07/04/2011
What I need is to change the query so that it will actually select the day before whatever was input.
So if a user puts in
The query will Select