Hi,
I have a field which comes with the value of MM/DD/YYYY HR:MN:SEC, THere is a limitation in our application that it cannot take the time part inside a date. What is the best way to remove the time in the date and update the field with only Date values like MM/DD/YYYY. I tried using set fromdate = Trunc(fromdate); which one of my friend suggested. which is not working.
Please suggest. Regards,
Ranjit