hi how to convert date field

[Anonymous]

Hi, i want to calculate lead time b/w two fields.

>>order date("MM/DD/YYYY") AND invoicedate(YYYY/MM/DD HH/MM/SS)

>>I want to convert the invoicedate into("MM/DD/YYYY") this format.

can any one have sol pls..

[#2]

Hi Arun,

Find the attachment.For any clarification let me know the same.

Thanks & Regards

Jai

[#3]

Hi Arun,

I have wrongly entered in the previous application.Check with this.

Thanks & Regards

Jai

[googel84]

Try this:

date(date#(left(invoicedate,10),"YYYY/MM/DD"),"MM/DD/YYYY")

With date# you tell the system that invoicedate (precisely its first 10 digits) has "YYYY/MM/DD" format; then you tell the system to convert invoicedate (that now it can recognize as a date field) into "MM/DD/YYYY" format.

[Anonymous]

Thanks for reply ijprakash

>>know i get the actual format.

[Anonymous]

hi thanks for reply.

its fine know.

[Anonymous]

hi thanks for reply.

its fine know.