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!

Off Topic Forums - General & Off Topic
Forum for off topic and general discussion. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General & Off Topic | New Thread

View: Search:

Author

Thread: DateDiff function in SalesLogix Scripting

Sundari Sinha
Posts: 36

DateDiff function in SalesLogix Scripting Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: DateDiff function in SalesLogix Scripting Your last visit to this thread was on 1/1/1970 12:00:00 AM

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)

[Reply][Quote]

Sundari Sinha
Posts: 36

Re: DateDiff function in SalesLogix Scripting Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Sep 09 2:42 PM

Thanks a Lot!

I tried with converting the dates to Double and it worked!

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/19/2024 5:02:54 AM