Hi,

Yes, we tested a bit and find #VALUE! error in AU2 cell.

We will figure out the issue soon.

Thank you.

Hi Rohit,

Please try this fix.

Wrote too soon, the fix provided by Warren works fine for the test cases.

Thanks Warren !!!

Thxs,

Rohit

Dear Rohit,

As DATEVALUE function , we only support the following date formats:

yyyy-MM-dd
yyyy-MM-dd HH:mm:ss
MM-dd-yyyy
MM/dd/yyyy
MMM dd-yyyy
MM-dd-yyyy hh:mm a
HH:mm:ss
HH:mm
yyyy/MM/dd
HH:mm:ss a
dd-MMM-yy
dd-MMM-yyyy
dd MMM yyyy

So please check your files which use this fuction, if there are some formats which are not in the list.Please post here and we will add them soon.

Hello Aspose Team,

 I encountered another data format which is not currently supported. The date format is Mon DD, yyyy (eg Jul 23, 2007)

Can this be supported too?

Thanks,

Rohit Oberoi

Hi,

We will support your required format for DATEVALUE function soon.

Thank you.

Hi,

Please try this fix. We have supported this format.

Thnxs Warren for the quick tunr around..but the fix doesn't seem to work..

The dates I have are "Jul 23, 2007" ; "Sep 20, 2012"

Please let me know

Thxs

Hi,

Please confirm that you are using the lastest version 1.8.2.21. If it still does not work,please post your file here.

Warren,

I am using the version you posted in previous reply. It still doesn't work.. I am attaching the fikle for you refernce

Thanks,

Hi Rohit,

Thanks for the template, Yes, it seams the DATEVALUE function produces #VALUE! error using your desired input date format.

We will check and figure it out soon.

Thank you.

Hi,

Please try this fix.

Sorry for my mistake. I did not see the "Space" before the year.