Hi Tool Man and David.....

Thanks for your replies....But I guess you have not seen in my previous post what I have done so far.....Here it is......

This is what I have...

Hi Guys,

I am still for any of your suugestions in solving this issue....This is waht I have tried so far :

I have created a dataset for office named dsoffice and...

Try this one:

FormatDateTime(Now,3)

Hi Niraj,

Thanks for ur reply.

Actually my problem is that I am having a rectangle (4 sided) image...now i want to put in my report...but i want to display only the...

Thanx Madhavinan...i got it....

but thr is a small probs still...

when i run tht query...i am getting data for only oct,nov and dec months...for the rest of the months...the rows r...

Thanx Madhvinan...for ur response

when i run the query which u have sended with my actual data...its working i.e i am getting the output correctly...but i am getting the following message...

hey jeff....actually i was trying for this one sterday whole day...and i came to know tht this can be done using cursors or function......so i created the below code using...

Thanx Jeff for ur response............

Hey guyz...

can anyone help me with the probs i have mentioned in the post...

thnx...

ok guyz..thanx for ur responses...i am trying to provide u more precise information...here it is---i am adding a new field ID and i got this extra information as well--

When the...

Hi Jeff...

thanx for ur help....here is the proper way....

CREATE TABLE customers (

Number [smallint] NULL ,

starting_point [varchar] (5) NULL ,

ending_point [varchar] (5) NULL

...

yes bryan..

for example if i am having something likt this :

datecolumn

26NOV

09DEC

18NOV

22DEC

then i shud get output like this:

26/11/

09/12/

18/11/

22/12/

the query which u have sended me....when i run it i am getting in...

Hi Bryan,

thr is a small probs i am facing when running the query which u have sended...

there r some null values in the datecolumn...and they r coming in the result...

yep i got it....

thnx for ur response bryan.........

thnx for ur reply...

i tried to run the query in the way u have suggested

select

substring(datecolumn,1,2)+ '/' +

replace(datecolumn,substring (datecolumn,3,3),month(datecolumn+'2007')) +'/' from temp_table

but i am getting the result in...