convert 11-dec into 12/11/2012

[#1]

hi experts,

how can i do this 

convert source format 11-dec into 12/11/2012 

[#2]

hi,

Don't you have any year information, so you want to hardcode year?

if you have 11-dec-2012 then you can use  date(date#([yourdatefield],'DD-MMM-YYYY')

but if you have only 11-dec anyway, you can use this

makedate(2012,month(date#([yourdatefield],'DD-MMM'),left([yourdatefield],2))

let me know, if it answers your question.

...

Ashutosh

[jagan]

Hi,

Try this

=date(date#([DateField] & '-2012' ,'DD-MMM-YYYY') )

Hope this helps you.

Regards,

Jagan.

[#4]

Hi,

Remember the Best practice should be when ever you get a Date field, You Must convert that into proper date

that is using Make date Function

MakeDate(), and pass the parameters which you have Date/Month/Year

refer help for this