Hello Bill
I hope you are doing great.
I have on job with two date variables "fromDate" and the current Date?
Is there a way that I can calculate the number of the days between the two dates to use in the command-Line Parameter?
Something like this: DateDiff(%fromDate% - GetDate())
I need one way to have the number of the days.
Please let me know if you need more details.
Thank you.
You can do this with an Inline Function that calculates the number of days.
Edit the InlineFunctions script library and add the following function definition to it (assuming that the library still is configured to use the default VB.NET language setting):
Staff
'Returns the number of full or partial days elapsed since the startDate
Public Function ElapsedDays(startDate As DateTime) As Integer
Return Math.Floor(DateTime.Today.Subtract(startDate.Date).TotalDays)
End Function
This can go anywhere in the module (make sure it goes before the "End Module" statement at the end.)
For the command line, use this:
%=ElapsedDays(fromDate)%
Hello Bill,
Thank for your support as always.
The function works great, but I noticed that sometimes it gives an error to randon steps that are using the function.
