#94036 - 12/29/03 09:54 AM
Date Field
|
addict
Registered: 04/17/03
Posts: 527
Loc: New Jersey
|
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
|
|
Top
|
|
|
|
|
|
#94037 - 12/29/03 10:18 AM
Re: Date Field
[Re: xmoreland]
|
Stealth Member
Registered: 03/11/04
Posts: 224
|
**
Roger,
You should be able to accomplish this using the DATEADD function. For example to set DateFieldA equal to DateFieldB + 30 days, this would be the set fields value:
DATEADD( "dd",30,$DateFieldB$)
There is a bug in the documentation that fails to indicate the required quotes around the datepart argument ("dd").
HTH,
Thomas
----- Original Message -----
From: Nall, Roger
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Monday, December 29, 2003 3:54 PM
Subject: Date Field
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
This posting was submitted via the Web interface
|
|
Top
|
|
|
|
|
|
#94038 - 12/29/03 11:22 AM
Re: Date Field
[Re: xmoreland]
|
addict
Registered: 04/17/03
Posts: 527
Loc: New Jersey
|
**
**
That worked great. Thanks for the info.
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
-----Original Message-----
From: Thomas Bean [mailto:tbean@CPICORP.COM]
Sent: Monday, December 29, 2003 5:19 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
Roger,
You should be able to accomplish this using the DATEADD function. For example to set DateFieldA equal to DateFieldB + 30 days, this would be the set fields value:
DATEADD( "dd",30,$DateFieldB$)
There is a bug in the documentation that fails to indicate the required quotes around the datepart argument ("dd").
HTH,
Thomas
----- Original Message -----
From: Nall, Roger
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Monday, December 29, 2003 3:54 PM
Subject: Date Field
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
This posting was submitted via the Web This posting was submitted via the Web interface interface
|
|
Top
|
|
|
|
|
|
#94039 - 12/31/03 07:39 AM
Re: Date Field
[Re: xmoreland]
|
Stealth Member
Registered: 03/11/04
Posts: 52
|
**
Is DATEADD a 5.12 feature? I ask because I'm in a 5.01 environment and don't see it in my function pick list off of a set field action.
-----Original Message-----
From: Nall, Roger [mailto:Roger.Nall@T-MOBILE.COM]
Sent: Monday, December 29, 2003 6:23 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
** **
That worked great. Thanks for the info.
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
-----Original Message-----
From: Thomas Bean [mailto:tbean@CPICORP.COM]
Sent: Monday, December 29, 2003 5:19 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
Roger,
You should be able to accomplish this using the DATEADD function. For example to set DateFieldA equal to DateFieldB + 30 days, this would be the set fields value:
DATEADD( "dd",30,$DateFieldB$)
There is a bug in the documentation that fails to indicate the required quotes around the datepart argument ("dd").
HTH,
Thomas
----- Original Message -----
From: Nall, Roger
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Monday, December 29, 2003 3:54 PM
Subject: Date Field
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
This posting was submitted via the Web This posting was submitted via the Web interface interface
This posting was submitted via the Web interface
|
|
Top
|
|
|
|
|
|
#94040 - 12/31/03 08:10 AM
Re: Date Field
[Re: xmoreland]
|
Stealth Member
Registered: 03/11/04
Posts: 224
|
**
Chris,
I believe this function was added in ARS 5.1, along with the new DATE and TIME field types. So if you are on ARS 5.0, you wouldn't have it (I'm assuming your full version number is 5.00.01).
--Thomas
----- Original Message -----
From: Danaceau, Chris
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Wednesday, December 31, 2003 1:39 PM
Subject: Re: Date Field
**
Is DATEADD a 5.12 feature? I ask because I'm in a 5.01 environment and don't see it in my function pick list off of a set field action.
-----Original Message-----
From: Nall, Roger [mailto:Roger.Nall@T-MOBILE.COM]
Sent: Monday, December 29, 2003 6:23 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
** **
That worked great. Thanks for the info.
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
-----Original Message-----
From: Thomas Bean [mailto:tbean@CPICORP.COM]
Sent: Monday, December 29, 2003 5:19 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
Roger,
You should be able to accomplish this using the DATEADD function. For example to set DateFieldA equal to DateFieldB + 30 days, this would be the set fields value:
DATEADD( "dd",30,$DateFieldB$)
There is a bug in the documentation that fails to indicate the required quotes around the datepart argument ("dd").
HTH,
Thomas
----- Original Message -----
From: Nall, Roger
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Monday, December 29, 2003 3:54 PM
Subject: Date Field
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
This posting was submitted via the Web This posting was submitted via the Web interface interface
This posting was submitted via the Web interface
This posting was submitted via the Web interface
|
|
Top
|
|
|
|
|
|
#94041 - 12/31/03 08:28 AM
Re: Date Field
[Re: xmoreland]
|
Stealth Member
Registered: 03/11/04
Posts: 52
|
**
Yes, we are on 5.00.01 here. Thanks for the info, Thomas.
cd
-----Original Message-----
From: Thomas Bean [mailto:tbean@CPICORP.COM]
Sent: Wednesday, December 31, 2003 3:11 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
**
Chris,
I believe this function was added in ARS 5.1, along with the new DATE and TIME field types. So if you are on ARS 5.0, you wouldn't have it (I'm assuming your full version number is 5.00.01).
--Thomas
----- Original Message -----
From: Danaceau, Chris
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Wednesday, December 31, 2003 1:39 PM
Subject: Re: Date Field
**
Is DATEADD a 5.12 feature? I ask because I'm in a 5.01 environment and don't see it in my function pick list off of a set field action.
-----Original Message-----
From: Nall, Roger [mailto:Roger.Nall@T-MOBILE.COM]
Sent: Monday, December 29, 2003 6:23 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
** **
That worked great. Thanks for the info.
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
-----Original Message-----
From: Thomas Bean [mailto:tbean@CPICORP.COM]
Sent: Monday, December 29, 2003 5:19 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Date Field
Roger,
You should be able to accomplish this using the DATEADD function. For example to set DateFieldA equal to DateFieldB + 30 days, this would be the set fields value:
DATEADD( "dd",30,$DateFieldB$)
There is a bug in the documentation that fails to indicate the required quotes around the datepart argument ("dd").
HTH,
Thomas
----- Original Message -----
From: Nall, Roger
Newsgroups: public.remedy.arsystem.general
To: ARSLIST@ARSLIST.ORG
Sent: Monday, December 29, 2003 3:54 PM
Subject: Date Field
**
Hello Everyone,
I am trying to set a DateFieldA equal to DateFieldB + 30 days. I know how to do this using Date/Time fields but I am getting an error trying the same method with Date Only fields. Can someone let me know how this can be accomplished?
TIA,
Roger A. Nall
T-Mobile USA
OSSNMS Remedy Administrator/Developer
Desk -973-644-3963
PCS-973-652-6723
Fax -973-490-3296
This posting was submitted via the Web interface
This posting was submitted via the Web This posting was submitted via the Web interface interface
This posting was submitted via the Web interface
This posting was submitted via the Web interface
This posting was submitted via the Web interface
|
|
Top
|
|
|
|
|
|
|
Previous Topic
Index