cancel
Showing results for 
Search instead for 
Did you mean: 

issue with datefromxmlformat / dateformat function in MII 12.2

Former Member
0 Kudos

Hi All,

I observed following issue with date format function in MII 12.2.

datefromxmlformat("2010-12-31T00:00:00", "w") --> reutns 1 instead of 52

also dateformat("12/31/2010","MM/dd/yyyy","w") --> Returns 1 instead of 52.

similarly I am facing issues with monthend function.

am I doing someting wrong for week calculation or this is issue with 12.2.

Please do let me know if there is any function to calculate number of weeks in year.

Regards,

Sachin

Edited by: sachinjadhavar on Aug 3, 2011 11:00 AM

Edited by: sachinjadhavar on Aug 3, 2011 11:01 AM

Edited by: sachinjadhavar on Aug 3, 2011 12:34 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Sachin,

Have you tested it in 12.0 or 12.1? If the results are different in the earlier version, please open a ticket.

Thanks,

Mike

Former Member
0 Kudos

Hi Sachin, Hi Mike,

I think it depends on what day of the week January 1st falls on. Even if January 1st is a Saturday, it is still considered week 1.

You can see what I mean by creating a transaction or local property of type "datetime" and then use calendar control to set the date. The week number is listed next to each week.

The functions work the same in 12.0, 12.1, and 12.2. I think it depends on what constitutes the definition of a "week".

Kind Regards,

Diana Hoppe