Advanced Fomular Of "weeknum(date)" Returns Week Falls Numerically With a Month Instead of Year
(Doc ID 2831490.1)
Last updated on JANUARY 03, 2022
Applies to:
Primavera Unifier - Version 20.12 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
According to the instruction in '?' help in unifier: weeknum(date) : Gets the number from a given date representing where the week falls numerically with a year. But when we check it in Sample Calculations, it returns week falls numerically with a month (not year).
STEPS TO REPRODUCE
- Find one generic BP. For e.g, generic Action Items BP.
- Any upper form.
- Properties.
- Select any string field , for e.g, Title.
- Advanced Formula.
- Date Functions: weeknum(date), and select any Date Data Element.
- Error Check.
- Check Sample Calculations, could see that it does not return week falls numerically with a year but return week falls numerically with month.
ADDITIONAL INFORMATION
The issue can be replicated in generic Unifier environment.
EXPECTED BEHAVIOR
Weeknum(date) should return week falls numerically with a year.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |