need help on this report query
hi
i have written this query for extracting all requests closed and resolved for last month along with the pending request for a particular department. the results are fine except for the requests with pending status = yes, i want to completed date to be empty, it shows the format that i set.
2. second thing, how can the output the created date and other dates to just show the date and not time??
can any one help me on this, plsssssss??? my backend is MSSQL
i have written this query for extracting all requests closed and resolved for last month along with the pending request for a particular department. the results are fine except for the requests with pending status = yes, i want to completed date to be empty, it shows the format that i set.
2. second thing, how can the output the created date and other dates to just show the date and not time??
can any one help me on this, plsssssss??? my backend is MSSQL