Creating folder - VisualCron - Forum

Community forum

Luqman
2019-12-24T02:20:47Z
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).
Gary_W
2019-12-24T15:02:21Z
I used your command and created a folder with the name you expected. Version 8.5.5.
Support
2019-12-29T11:10:44Z
Originally Posted by: Luqman 

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)}})}
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top