Hi Team,

I want to create a folder with the name = 2085 (WK51_2019). I've been using this statement to name my folder :

{MATH(Divide|Integer|{DATE(DaysBetween|1/7/1980|{DATEFORMAT(M/d/yyyy)})}|7|#0)}(WK{MATH(Subtract|Integer|{DATE(Week)}|1|#0)}_{DATEFORMAT(yyyy)})

which the output based on variables is 2085 (WK51_2019). But when I try to create the folder, it shown 0 (WK51_2019), not 2085 (WK51_2019).

I used your command and created a folder with the name you expected. Version 8.5.5.

Hi Team,

I want to create a folder with the name = 2085 (WK51_2019). I've been using this statement to name my folder :

{MATH(Divide|Integer|{DATE(DaysBetween|1/7/1980|{DATEFORMAT(M/d/yyyy)})}|7|#0)}(WK{MATH(Subtract|Integer|{DATE(Week)}|1|#0)}_{DATEFORMAT(yyyy)})

which the output based on variables is 2085 (WK51_2019). But when I try to create the folder, it shown 0 (WK51_2019), not 2085 (WK51_2019).

The reason why you might get the 0 is because of this method:

{DATE(DaysBetween|1/7/1980|{DATEFORMAT(M/d/yyyy)})

I suspect that the date format is wrong. This worked for me:

{DATE(DaysBetween|1980-07-01|{DATEFORMAT(yyyy-MM-dd)}})}

---