on 08-03-2011 9:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.