Loading

how to set date as client requirment

Dharmesh Sharma

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa16y ago
Accepted 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 Dharmadasa16y ago
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.