12/15/2025 1:35:00 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum for off topic and general discussion. View the code of conduct for posting guidelines.
|
|
|
|
DateDiff function in SalesLogix Scripting
Posted: 09 Sep 09 8:06 AM
|
Hello,
I am trying to use DateDiff function to get the number of days between today and the PaymentDate
in SalesLogix Scripting. And then I have to use the return value to validate in my code. But when I test it-
It is not giving me error but the returns 0 no matter what date I put in Paymtstart.
Is DateDiff() Supported in SLX scripting?
Below is my code-
Dim PayStart, Today ,PS
PayStart = GetPropertyOf ("Paymtstart", "Text")
Today = Date()
PS = DateDiff("d",Today,PayStart)
msgbox(PayStart)
msgbox(Today)
msgbox(PS)
Any suggestions?
Thanks,
Sundari
|
|
|
|
Re: DateDiff function in SalesLogix Scripting
Posted: 09 Sep 09 11:40 AM
|
Are you working with Legacy Code here? (it appears so given that you are using GetPropertyOf).
If possible switch over to an ActiveForm, the script behind it will work.
If you need to stay on Legacy code, there are 2 ways around it:
Use Global Variables and an Invoke call to an Active Script which then calls the DateDiff and returns a value on a Global Variable.
Or:
Convert your Dates to Double and then figure it out
Dim dblToday as Double
Dim dblDate as Double
dblToday = CDbl(Date())
dblDate = CDbl(CDate(PayStart))
msgbox CInt(dblToday - dblDate)
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|