Formatting a date displayed in a crystal report

[steve_rm]

Hello

I am using VS 2005 CR 10.

I am using typed datasets to populate a report.

From my database I have 1 field called incidentDate, this is a smallTimeDate datatype.

My reports always displayes the correct date, but is followed by the time which is always 12:00. For example 18/12/2006 12:00 AM.

I don't want to display this time. I have tried setting the DateWindowsDefaultType in the report properties for that field. But this did not work.

Does anyone have any other ideas,

Thanks very much,

Steve

[shakti5385]

Right click on the Date and click on the Format and select the date from There.

[steve_rm]

Thanks for your answer Shakti, but it didn't work.

I did the right click | format object | I selected the format 12/12/2006 and then clicked ok. But did not work.

I also deleted the field and inserted a new one, and did the same as above, but it always displayes this "12/12/2006 12:00:00 AM".

I want to get rid of this time, its driving me nuts.

Any ideas I would be most grateful.

Steve

[shakti5385]

If your variable is date Type then the Format will be work , Other thing you can do that just make a formula and put the variable in the formula and change format there.

[steve_rm]

Thanks Shakti,

It did work what you said. I did that before, but I was loading the wrong report. Just released my mistake.

However, I am interested in this formula. Can you give me some sample code on how to write this formula. I would like to learn how to do this.

Many thanks for your help,

Steve

[mabbas110]

i think it would be like this

cdate(left(datetimevar,8)

[steve_rm]

Thanks,

I will give that a try.

[mabbas110]

IF my syntax has helped u then do rate it and pls mark resolved to this problem.