While condition after certain date

Hi. I want to count back the month and stop at certain date(ex:201801).I set the condition ,but it just execute continuously. Please help set the right condition THX


S:variable type-Datetime Default-Now

Try it with once while loop
in while condition your comparing string variables better to use to date variable only like S(DateVariable)<“201801”(date variable)


I would recomend using string to compare dates because then you depend on the format of the string (because every character is compared one to one. example: 31.12.2018<01.01.2019 but “31.12.2018”>“01.01.2019”). If you want to do it in a loop with string, then force the format (as you do in the message box)

“I would not recomend”

I modify my condition like


then it works! THX

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.