11/26/2024 8:21:51 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 to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Need help with 'DB Change' setting in creating a contact process
Posted: 13 Nov 06 7:17 AM
|
fiogf49gjkf0d Hi,
SLX: 6.2
I have a contact process that schedules an email to be sent to a contact in 6 months time. I have a datetime field on the contact form. It would be really nice if I could get the contact process to automatically populate this field with today's date when the process is initiated as well.
However, I cannot seem to get the syntax right. When I add the 'DB Change' command to the process, I tie it to the correct database field and try setting the 'New Value' to GetDate()
However, this does not work. Can anyone tell me the syntax to get this to populate the field with today's date?
Thanks |
|
|
|
Re: Need help with 'DB Change' setting in creating a contact process
Posted: 13 Nov 06 1:49 PM
|
fiogf49gjkf0d VBScript has the Now() function. I believe Enable Basic uses it as well (Legacy). GetDate() is straight SQL, and most likely isn't recognized. There's also the FormatDateTime(Now, vbShortDate) function which will return today's date in the format 11/13/2006 without the time. |
|
|
|
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!
|
|
|
|
|
|
|
|