Page 1 of 1
Number of days between two dates (dd/mm/yyyy)
Posted: Sat Apr 09, 2016 4:46 pm
by marcolobaido
Hi everybody,
How can I obtain the number of days between two dates: date1 - date2 = number of days (where date1>date2).
I tried to use the "VBscript" function but it's too complex for me, I should learn the programming language.
Re: Number of days between two dates (dd/mm/yyyy)
Posted: Mon Apr 11, 2016 3:01 pm
by Oleg
See the example below.
Only one string on VBscript
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|444033236
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task116"
Hide=INTEGER|0
ID=INTEGER|843892749
LogOnAsUser=INTEGER|1
Name=STRING|"days between"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
UnicodeFormat=INTEGER|1
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
[Actions\Action1]
ActionID=STRING|"A_MISC_COMMENT"
Enabled=INTEGER|-1
Name=STRING|"//d2 > d1"
Params=FOLDER
[Actions\Action1\Params]
comment=STRING|"d2 > d1"
[Actions\Action2]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""D1"" with value ""{DateTimeToFormat({DateIncDays(-20)},dd/mm/yyyy)}"""
Params=FOLDER
[Actions\Action2\Params]
expand=STRING|"1"
varname=STRING|"D1"
varvalue=STRING|"{DateTimeToFormat({DateIncDays(-20)},dd/mm/yyyy)}"
[Actions\Action3]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""D2"" with value ""{DateTimeToFormat({DateIncDays(7)},dd/mm/yyyy)}"""
Params=FOLDER
[Actions\Action3\Params]
expand=STRING|"1"
varname=STRING|"D2"
varvalue=STRING|"{DateTimeToFormat({DateIncDays(7)},dd/mm/yyyy)}"
[Actions\Action4]
ActionID=STRING|"A_SCRIPT_VBEVALUATE"
Enabled=INTEGER|-1
Name=STRING|"VB Evaluate"
Params=FOLDER
[Actions\Action4\Params]
expression=STRING|"DateDiff(""d"", ""{FormatToDateTime({d1},dd/mm/yyyy)}"", ""{FormatToDateTime({d2},dd/mm/yyyy)}"" )"
linecount=STRING|"0"
loadfromfile=STRING|"1"
variable=STRING|"dif"
[Actions\Action5]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""d1 = {d1}"""
Params=FOLDER
[Actions\Action5\Params]
icon=STRING|"1"
msg0=STRING|"d1 = {d1}"
msg1=STRING|"d2 = {d2}"
msg3=STRING|"dif = d2 - d1 = {dif}"
msgcount=STRING|"4"
playsound=STRING|"0"
showmessage=STRING|"1"
Re: Number of days between two dates (dd/mm/yyyy)
Posted: Mon Apr 11, 2016 3:31 pm
by marcolobaido
thank you very much!!!
