how to set date as client requirment

Question

hi

i m using window form and one datetimepicker and i m set custom formate in datetimepicker as dd/MM/yyyy now is sql save formate and i use on my report but
client want to date like 11-Dec-09
but mu date is 11/12/2009
how to convert in windwo form
or sql

is any idea in sql to convert date like 11-dec-09

if not
then in window programming

please help me

Nilanka Dharmadasa · Answer

Hi Sharma If you want to change the display format of a date in the crystal report the follow this way. Go to report designer. Select the date field and right click. Then select 'Format field..' Then go to tab ' Date' Then select the format you like. Then click OK. If you find my answer useful please check 'Do you like this answer' checkbox.

Nilanka Dharmadasa · Answer

Hi Shrma Youe question is not exactly clear. You want to display date like below in datetimepicker or in crystal report? ' 11-dec-09 ' Anyway you do not have to worry about database. What you should do is changing the display format. Not the data. Let me know clearly.