A
amr09
Guest
Here's the problem, i need to create a date range on the variable below.
define variable s_date as character format "99/9999" no-undo.
There is a start_date column in my db (format "99/99/9999"(dd/mm/yyyy)) the date when a customer sales order was entered.
What i need to do is set the variable to create the date range, search and display the results of every sales order of the defined month and year.
PS: I 'm using a form , so the user can define the range of the month and year.
Continue reading...
define variable s_date as character format "99/9999" no-undo.
There is a start_date column in my db (format "99/99/9999"(dd/mm/yyyy)) the date when a customer sales order was entered.
What i need to do is set the variable to create the date range, search and display the results of every sales order of the defined month and year.
PS: I 'm using a form , so the user can define the range of the month and year.
Continue reading...