08-20-2018 06:36 AM - edited 03-14-2019 06:25 PM
Hi
I am trying to figure out a way to take two dates in format of DD/MM/YYYY and create a value of the difference
e.g.CCX Editor CCX Editor
String 1 = 18/08/2018
String 2 = 20/08/2018
Then some how with a set feature maybe create a new string that equals the difference
so String 3 = 2
Anyone know if this is possible or recommend a better way to do it.
Ultimately what I want to do in the end is have an increment of days and after x number of days ( 7 in this case) do something else so would end up running a different aspect of the script
Sort of if (String 3 =<7) Then
Thanks in advance
Solved! Go to Solution.
08-20-2018 10:22 AM
I'm not sure if I would evaluate it as a variable type String. You could actually change the dates to "day of the year" using the .doy function and mathematically evaluate them. Once you calculate difference use a logic palette item or evaluation (switch, if / then, etc.) to follow the path you want your script to go down...
I toyed with it this way:
08-20-2018 10:22 AM
I'm not sure if I would evaluate it as a variable type String. You could actually change the dates to "day of the year" using the .doy function and mathematically evaluate them. Once you calculate difference use a logic palette item or evaluation (switch, if / then, etc.) to follow the path you want your script to go down...
I toyed with it this way:
08-21-2018 02:28 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide