t;
>> On Tue, May 2, 2017 at 6:20 AM, Dave Barber <daddy.bar...@gmail.com>
>> wrote:
>>
>>> **
>>> All,
>>>
>>> We have a form, used as part of a notifications system, it has a 255
>>> character field with a default value as $
some difference...
>
> On Tue, May 2, 2017 at 6:20 AM, Dave Barber <daddy.bar...@gmail.com>
> wrote:
>
>> **
>> All,
>>
>> We have a form, used as part of a notifications system, it has a 255
>> character field with a default value as $TIMESTAM
have a form, used as part of a notifications system, it has a 255
> character field with a default value as $TIMESTAMP$. So in theory it
> should store a value 02/05/2017 08:13:40 (UK/GMT date format)
>
> We've recently gone through a series of upgrades, from Remedy 7.6.04 (on
&g
All,
We have a form, used as part of a notifications system, it has a 255
character field with a default value as $TIMESTAMP$. So in theory it
should store a value 02/05/2017 08:13:40 (UK/GMT date format)
We've recently gone through a series of upgrades, from Remedy 7.6.04 (on
Solaris
Hi all,
The server is located in CET timezone and we have customers globally.
In the template based outgoing email notifications, timestamp shows in CET
format.
I want to display timestamp in GMT format instead of CET.
Please let me know if this can be achieved.
Regards,
Robin
No luck? Still converts to the literal Timestamp, just in double quotes.
--
Thank You,
Chris Danaceau
FINRA
240-386-6728 (desk)
301-367-8949 (cell)
Remedy FAQhttp://wiki.finra.org/confluence/display/TechOpsCtr/Remedy+FAQ
From: Action Request System discussion list(ARSList)
[mailto:arslist
Hi Chris,
If you change request directly goes to implementation phase means You can
try $TIMESTAMP$ + 3600 .
Thanks,
Dinesh kumar.
On Wed, Mar 26, 2014 at 6:12 PM, Danaceau, Chris
chris.danac...@finra.orgwrote:
**
No luck? Still converts to the literal Timestamp, just in double quotes
Just a guess (not near a server right now):
$\TIMESTAMP$
Joel
Joel Senderjdsen...@earthlink.net310.829.5552
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dinesh Kumar
Sent: Wednesday, March 26, 2014 8:23 AM
To: arslist
Hi Listers,
I'm trying to map the current $TIMESTAMP$ as the default value for a variable
that maps to the Scheduled Start Date on a Change Request ticket created from a
Service Request. If I use $TIMESTAMP$ it is converted immediately to the
current Timestamp. Obviously not what I want
Try putting it in double-quotes:
$TIMESTAMP$
HTH,
Joel
Joel Senderjdsen...@earthlink.net310.829.5552
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Danaceau, Chris
Sent: Tuesday, March 25, 2014 11:22 AM
To: arslist@ARSLIST.ORG
: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Tuesday, July 09, 2013 9:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: parsing timestamp in diary field using Crystal or Remedy
**
Count the number of those 'square' type of characters
Does anyone have formula or workflow that loop through the diary field to
parse out the date or timestamp either through Crystal Report or Remedy?
Thanks in advance
___
UNSUBSCRIBE or access ARSlist Archives
the date or timestamp either through Crystal Report or Remedy?
Thanks in advance
_ARSlist: Where the Answers Are and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where
Lj,
Thank you for responding. I am using Crystal with Remedy ODBC driver.
What I am trying to do is parsing out each timestamp entry in the diary
field without the text content or do a count for each entry in the diary
field. I don't what else would be the best common key that I could use to
do
on
it.
On Tue, Jul 9, 2013 at 7:06 AM, Remedy Lister remedy.lis...@gmail.comwrote:
**
Lj,
Thank you for responding. I am using Crystal with Remedy ODBC driver.
What I am trying to do is parsing out each timestamp entry in the diary
field without the text content or do a count for each entry
driver.
What I am trying to do is parsing out each timestamp entry in the diary
field without the text content or do a count for each entry in the diary
field. I don't what else would be the best common key that I could use to
do this except working with the timestamp in the diary field.
Thanks
contents, without really poking into real data to have a look at it.
Joe
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Lister
Sent: Tuesday, July 09, 2013 9:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: parsing timestamp in diary
ran into
something along similar lines today an wondered if anyone else has seen
something similar. We have a set of filters that put $TIMESTAMP$ into
date/time fields, one per status value (i.e. if there are five different
status values there will be five date/time fields
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, June 12, 2013 20:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
**
One thing I have seen is $TIMESTAMP$ is only set at the beginning of the filter
cycle. If you want
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Thursday, June 13, 2013 11:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
**
Interesting! I will have to give that a try. The problem doesn't happen to all
first-call resolution
Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 13, 2013 9:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
As you are working with Filters the time zone
-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Thursday, June 13, 2013 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
Good point, I realized after I sent my reply that the previous
In light of the other thread about Create Date vice Modified Date I ran into
something along similar lines today an wondered if anyone else has seen
something similar. We have a set of filters that put $TIMESTAMP$ into date/time
fields, one per status value (i.e. if there are five different
$TIMESTAMP$ from filters
In light of the other thread about Create Date vice Modified Date I ran into
something along similar lines today an wondered if anyone else has seen
something similar. We have a set of filters that put $TIMESTAMP$ into
date/time fields, one per status value (i.e
D'Souza
Sent: Wednesday, June 12, 2013 14:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
**
My guess is that the create date is set at the same time that the Request ID is
set, as that would be the true create date stamp, at the time the Request ID
: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent: Wednesday, June 12, 2013 5:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Create Date later than $TIMESTAMP$ from filters
Thanks Joe. If I remember correctly on submit of a new request
One thing I have seen is $TIMESTAMP$ is only set at the beginning of the filter
cycle. If you want the real time inside a filter you need to use
$SERVERTIMESTAMP$
Fred
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock
Sent
Folks,
My transfers from a 6.3 server to a 7.1 server via Migrator 7.1.00 p006 set the
Last Changed Time on each imported object to the time of creation on the
server. I thought this might be a problem with the Migrator mask setting,
but the same thing happens when definitions that have the
Hi,
This is how it works in any version, unfortunately...
Best Regards - Misi, RRR AB, http://rrr.se
Folks,
My transfers from a 6.3 server to a 7.1 server via Migrator 7.1.00 p006
set the Last Changed Time on each imported object to the time of creation
on the server. I thought
Sent: Thursday, April 12, 2012 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Transferred Object Last Changed Value Set to Timestamp
Hi,
This is how it works in any version, unfortunately...
Best Regards - Misi, RRR AB, http://rrr.se
-Original Message-
From: Action Request System
before.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Thursday, April 12, 2012 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Transferred Object Last Changed Value Set to Timestamp
Hi,
This is how
: Transferred Object Last Changed Value Set to Timestamp
**
Folks,
My transfers from a 6.3 server to a 7.1 server via Migrator 7.1.00 p006 set the
Last Changed Time on each imported object to the time of creation on the
server. I thought this might be a problem with the Migrator mask setting,
but the same
Code... not data.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Thursday, April 12, 2012 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Transferred Object Last Changed Value Set to Timestamp
Value Set to Timestamp
**
Everyone,
If you use the Import Tool, simply map the Last Modified Date and Last
Modified User fields from
the source to the target. It uses the ARMergeEntry() call and if those
fields are supplied, the AR System
Server will retain them and not set these fields
11:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Transferred Object Last Changed Value Set to Timestamp
**
Hi Doug
I *think* he is referring to importing workflow objects, not form data. The
modified date is indeed set to the current date in that situation.
Even more annoying for me
a
change to the structure definition
of the server.
Well, when you load a new object from another environment, it is NEW to the
current environment.
Keeping the date from that other environment will not allow the current server
to see that it is a new
object as it uses that timestamp to tell
for date/timestamp fields
Chintan,
The TimeZone should be located on the Locale tab of the AR System User
Preference form. If you don't have a record for the login you are using you
can create one.
Also ... What OS is your Mid-Tier running on?
-Original Message-
From: Action Request System
.
From: Andrew C Goodall ago...@jcpenney.com
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 16, 2011 12:30 PM
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
**
Sean has a good point – also check
the user account you are using to authenticate, and check its “AR
/timestamp fields
**
It uses the timezone of the device
executing the java – if that sits on the client then it uses the timezone
of that device.
What is the timezone of the clients
machine?
Regards,
Andrew Goodall
Software Engineer 2 | Development Services
| jcpenney . www.jcp.com
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah
Sent: Thursday, November 17, 2011 2:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
**
I already did that. It is set to Pacific Standard Time GMT-8 and hence I was
expecting -8
.
From: Grooms, Frederick W frederick.w.gro...@xo.com
To: arslist@ARSLIST.ORG
Sent: Thursday, November 17, 2011 6:03 AM
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
Chintan,
The TimeZone should be located on the Locale tab of the AR System User
Preference
Hello all,
I am getting an element back from Web-service which looks like this
ns0:Create_Date2011-11-09T05:00:00-07:00/ns0:Create_Date
Now, question I have is who sets -07:00?
Is it hard-coded in midtier code or does mid-tier gets the timezone from
preference form for default midtier user?
/
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah
Sent: Wednesday, November 16, 2011 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Web-service Timezone question for date/timestamp fields
Hello all,
I am getting
...@jcpenney.com
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 16, 2011 10:50 AM
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
**
Comes from the timezone of the ARS server
I believe that executes the web service filter action.
e.g. try changing your server timezone and
see
@ARSLIST.ORG] On Behalf Of Chintan Shah
Sent: Wednesday, November 16, 2011 3:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
**
Hi Andrew,
I am sorry, I should have been more clear. I am consuming a web-service outside
of web-service filter action
/
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chintan Shah
Sent: Wednesday, November 16, 2011 2:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Web-service Timezone question for date/timestamp
fields
Hi Andrew
question for date/timestamp
fields
Check the user that you are authenticating with for the web service call
(you must pass in a user name and password). My guess is the user's
settings are -7. It should be in the user's application preferences.
Sean
From: Action Request System
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 16, 2011 12:07 PM
Subject: Re: Remedy Web-service Timezone question for date/timestamp fields
**
Check the user that you are authenticating with for the web service call (you
must pass in a user name and password). My guess is the user’s settings
: Monday, October 04, 2010 3:59 PM
To: arslist@ARSLIST.ORG
Subject: [AKO Warning - Message fails DKIM verification] Re: Keywords -
TIME and TIMESTAMP
Yes, use a Filter. That's the only way to get it to use the server time
instead of client. You could write an AL that sets a 'trigger' field
: Re: [AKO Warning - Message fails DKIM verification] Re: Keywords -
TIME and TIMESTAMP
If you are on ARS 7.5+, you can also use a Service action to call the
filter. Or use the keyword $SERVERTIMESTAMP$ instead.
Mike Luttmann
Fort Carson NEC
-Original Message-
From: Action Request
There is also $SERVERTIMESTAMP$ if your on 7.1
Saby
--- On Mon, 10/4/10, Joe Martin D'Souza jdso...@shyle.net wrote:
From: Joe Martin D'Souza jdso...@shyle.net
Subject: Re: Keywords - TIME and TIMESTAMP
To: arslist@ARSLIST.ORG
Date: Monday, October 4, 2010, 10:34 PM
Use Filters as opposed
Is there a way to force the $TIME$ function to use the server time?
We were going to use this to do some very time specific analysis, but
found out that if Joe Blow had his time zone wrong on his machine it
would set the time incorrectly.
$TIME$ = 12:30 PM
$TIMESTAMP$ = 2:30 PM
Thanks
: Keywords - TIME and TIMESTAMP
Is there a way to force the $TIME$ function to use the server time?
We were going to use this to do some very time specific analysis, but
found out that if Joe Blow had his time zone wrong on his machine it
would set the time incorrectly.
$TIME$ = 12:30 PM
on his machine it
would set the time incorrectly.
$TIME$ = 12:30 PM
$TIMESTAMP$ = 2:30 PM
Thanks!
Claire Sanford
Information Systems Division
Memorial Hermann Healthcare System
Phone: 713 448 6035
claire.sanf...@memorialhermann.org
Yes but its available only after version 7.0
Joe
From: Thad Esser
Sent: Monday, October 04, 2010 5:39 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Keywords - TIME and TIMESTAMP
** Could you use $SERVERTIMESTAMP$?
$SERVERTIMESTAMP
)
[mailto:arsl...@arslist.org] On Behalf Of Joe Martin D'Souza
Sent: Monday, October 04, 2010 4:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Keywords - TIME and TIMESTAMP
Use Filters as opposed to Active Links when setting that field..
Joe
--
From
: Re: Keywords - TIME and TIMESTAMP
I was just using $TIME$ as the value for the field.
Can I have the filter use the value $TIME$ ? Set on Submit $TIME$ and
have it pull the server time? I don't want the full date/time stamp.
Just the time of day.
-Original Message-
From: Action Request
] On Behalf Of Sanford, Claire
Sent: Monday, October 04, 2010 3:32 PM
To: arslist@ARSLIST.ORG
Subject: Keywords - TIME and TIMESTAMP
Is there a way to force the $TIME$ function to use the server time?
We were going to use this to do some very time specific analysis, but
found out that if Joe Blow had
Man..I always forget about that one :D
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Thad Esser
Sent: Monday, October 04, 2010 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Keywords - TIME and TIMESTAMP
** Could you use $SERVERTIMESTAMP
Besides SERVERTIMESTAMP is for DATE and TIME field and not for TIME only..
Joe
From: LJ LongWing
Sent: Monday, October 04, 2010 5:59 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Keywords - TIME and TIMESTAMP
**
Man..I always forget about that one :D
, October 04, 2010 5:39 PM
*Newsgroups:* public.remedy.arsystem.general
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Keywords - TIME and TIMESTAMP
** Could you use $SERVERTIMESTAMP$?
$SERVERTIMESTAMP$
For Date
..
Joe
*From:* LJ LongWing lj.longw...@gmail.com
*Sent:* Monday, October 04, 2010 5:59 PM
*Newsgroups:* public.remedy.arsystem.general
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Keywords - TIME and TIMESTAMP
**
Man….I always forget about that one :D
*From:* Action Request System
@ARSLIST.ORG
Subject: Re: Keywords - TIME and TIMESTAMP
** According to the help text, you can use $SERVERTIMESTAMP$ in a time field.
I've never used it that way, but it says it should work.
Thad
On Mon, Oct 4, 2010 at 3:02 PM, Joe Martin D'Souza jdso...@shyle.net wrote:
**
Besides
Hi All,
I have one Date/Time field.
On Windows loaded that field populate with Timestamp using activelink.
But When I search on the form that has Date/TimeField it shows no
record altough it have many records.
Please give me some suggestion how to come out of this problem
Search Problem in TimeStamp Using Activeline condtion windows loaded
Hi All,
I have one Date/Time field.
On Windows loaded that field populate with Timestamp using activelink.
But When I search on the form that has Date/TimeField it shows no
record altough it have many records.
Please give me some
)
arsl...@arslist.org
02/21/2010 05:54 PM
Please respond to
arsl...@arslist.org
To
arsl...@arslist.org
cc
Subject
Search Problem in TimeStamp Using Activeline condtion windows loaded
Hi All,
I have one Date/Time field.
On Windows loaded that field populate with Timestamp using activelink
: Re: Search Problem in TimeStamp Using Activeline condtion windows
loaded
**
Is it possible that you've set that to be a Display Only date/time field?
Remedy Beginner ketanpatel...@gmail.com
Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG
02/21/2010 05:54 PMPlease
Hello All,
Let me clarify Here.
I have one form that has only one field Date/Time Field.
On Windows Loaded It populate with TimeStamp using Active link.
After I Saved record in that form.
When I search it it shows an error No Record Matching
I enable logging and tried to find out the root cause
...@arslist.org]on Behalf Of Remedy Beginner
Sent: Sunday, February 21, 2010 6:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Search Problem in TimeStamp Using Activeline condtion
windows loaded
Hello All,
Let me clarify Here.
I have one form that has only one field Date/Time Field.
On Windows Loaded
Are you doing an unqualified search? If yes are you sure the fields are empty
(CTRL E) before search
-Original Message-
From: Remedy Beginner [ketanpatel...@gmail.com]
Date: 02/21/2010 06:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Search Problem in TimeStamp Using Activeline condtion
[ketanpatel...@gmail.com]
Date: 02/21/2010 06:43 PM
To: arsl...@arslist.org
Subject: Re: Search Problem in TimeStamp Using Activeline condtion windows
loaded
Hello All,
Let me clarify Here.
I have one form that has only one field Date/Time Field.
On Windows Loaded It populate with TimeStamp
in TimeStamp Using Activeline condtion windows
loaded
Hello All,
Let me clarify Here.
I have one form that has only one field Date/Time Field.
On Windows Loaded It populate with TimeStamp using Active link.
After I Saved record in that form.
When I search it it shows an error No Record
I need a formula that converts the remedy timestamp into oracle date/time
field...
I have referred to KB article:6132 and formula given in the article
is not working...
SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/ HH24:MI:SS') +
(C3 / ( 60 * 60 * 24 )),
'MM/DD/YY HH24:MI:SS
University
- Original Message -
From: surya4u meetsury...@gmail.com
Date: Monday, February 2, 2009 2:53 pm
Subject: Converting remedy timestamp into oracle date/time format
To: arslist@ARSLIST.ORG
I need a formula that converts the remedy timestamp into oracle date/time
field...
I
Architecture and Automation
860-766-4761
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of surya4u
Sent: Monday, February 02, 2009 2:53 PM
To: arslist@ARSLIST.ORG
Subject: Converting remedy timestamp into oracle date/time
Has anyone been able to import a timestamp from an external database
using AIE data mappings, where the souce data is an a millisecond unix
timestamp format.
I can execute SQL statements directly in the source database to
maniuplate the data, but AIE will not import the data due to it being
As soon as I posted this, I discovered I could successfully use a
syntax like this:
SQL|SELECT CAST (LastScanDate / 1000 as int) FROM tablename
On May 19, 4:41 pm, googerb [EMAIL PROTECTED] wrote:
Has anyone been able to import a timestamp from an external database
using AIE data mappings
me how I can
get the Work Log to display properly formatted timestamps in a direct sql
query that looks like this:8/26/2006 2:36:22 PM and not like this:
1155331936
Thanks
Brooks
ARSystem 7.00
SQL Server 2005
--
View this message in context:
http://www.nabble.com/HPD_HeldDesk-Worklog-timestamp
ODBC driver?
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of brooksm
Sent: Friday, January 04, 2008 3:30 PM
To: arslist@ARSLIST.ORG
Subject: HPD_HeldDesk Worklog timestamp conversion
Hello All
I am using SQL
Of brooksm
Sent: Friday, January 04, 2008 3:30 PM
To: arslist@ARSLIST.ORG
Subject: HPD_HeldDesk Worklog timestamp conversion
Hello All
I am using SQL Server Reporting Services for my reporting application and
the ARSystem ODBC driver is throwing up errors when I use it to connect to
ARSystem, so I
(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of brooksm
Sent: Friday, January 04, 2008 4:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: HPD_HeldDesk Worklog timestamp conversion
Hey Joe-
I'm using Visual Studio 2005 (Reporting Services) to connect to ARSystem.
When I do use the AR ODBC driver I get
@ARSLIST.ORG
Subject: Re: HPD_HeldDesk Worklog timestamp conversion
Hey Joe-
I'm using Visual Studio 2005 (Reporting Services) to connect to ARSystem.
When I do use the AR ODBC driver I get this error: Column 'TABLE_CAT'
does
not belong to table Tables. It's also documented here:
http
(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Benjamin Trimmer
Sent: Tuesday, October 02, 2007 6:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Convert Date in to timestamp in remedy
**
UPDATE [table2]
SET [field_to_modify] = DATEADD(s, [Remedy_DT_Field] + [additional time
in seconds if necessary
:27 PM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Convert Date in to timestamp in remedy
Hi,
We are using ARS 6.3, MS SQL. I want to update a date field using direct
sql - can some one help me with this.
Is there a function to convert the date field
Hi Benjamin,
Appreciate your response but what I am looking for is an update statement
that sets the date field using a Remedy date field.
Atul
- Original Message -
From: Benjamin Trimmer
To: arslist@ARSLIST.ORG
Subject: Re: Convert Date in to timestamp in remedy
Date: Tue, 2
07:49 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: Convert Date in to timestamp in remedy
**
Hi Benjamin,
Appreciate your response but what I am looking for is an update statement
that sets the date field using a Remedy date field.
Atul
- Original
PM
Subject: Convert Date in to timestamp in remedy
Hi,
We are using ARS 6.3, MS SQL. I want to update a date field using direct
sql - can some one help me with this.
Is there a function to convert the date field in to timestamp or can I use
the sql to update the date field directly.
Thanks
Hi,
We are using ARS 6.3, MS SQL. I want to update a date field using direct sql -
can some one help me with this.
Is there a function to convert the date field in to timestamp or can I use the
sql to update the date field directly.
Thanks
Atul
Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Atul Vohra
Sent: Monday, October 01, 2007 11:28 PM
To: arslist@ARSLIST.ORG
Subject: Convert Date in to timestamp in remedy
Hi,
We are using ARS 6.3, MS SQL. I want to update a date field using
Hello Listers,
ARServer 7.0.01
HelpDesk 6.0
I just noticied a weird anomaly regarding our Mid-Tier.
1) User creates a HD Case from website using the mid-tier.
2) Case worklog is updated from client in Central Standard Time. Case
Worklog shows correct CST $TIMESTAMP$ in worklog.
3) User views
21, 2007 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier $TIMESTAMP$ Question
**
Hello Listers,
ARServer 7.0.01
HelpDesk 6.0
I just noticied a weird anomaly regarding our Mid-Tier.
1) User creates a HD Case from website using the mid-tier.
2) Case worklog is updated from client
My understand about mid-tier and timestamp is that it only does that if you
are using a preference server and it uses the timezone in that preference
record. Otherwise it uses the server timezone
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf
could be over ridden with Preference Server settings as
noted by L. J. Head.
Dave
From: Jase Brandon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2007 12:26 PM
To: Shellman, David
Subject: FW: Mid-Tier $TIMESTAMP$ Question
Hi Dave,
Yep, the OS on the mid
Simple question, I think. Where does timestamp time come from? I have two
workstations on my desk, one my regular one with my time on the east coast.
The other a vista box, always has the wrong time and is usually colorado
time. I manually change it every day. When I submit tickets into remedy
James,
Timestamp comes from the server. You need to look at the time zone
there. Remember that each user can adjust the time that they see in
there user preferences. So someone in CA will see the time in the
Pacific Time Zone when the actual timestamp could be in say Eastern.
HTH,
Roger A. Nall
Roger is correct on the $TIMESTAMP$ variable, but for things like Diary
field settings, it depends on whether the action that caused the time entry
to occur was client or server driven.
Client generated actions (i.e. in Active Links) will push the client time.
Server generated actions (Filters
We have also encountered an inconsistency with MS Vista. Specifically:
Experiment was: observe the same helpdesk record (HD 5.5) with:
- Windows UT, XP -- timestamp correct and local
- MT, IE 7.0, XP -- timestamp correct and local
- MT, IE 7.0, Vista -- timestamp reading GMT (sorry, old
.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Don McClure
Sent: Thursday, July 12, 2007 12:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: timestamp
We have also encountered an inconsistency with MS Vista. Specifically:
Experiment
time
behavior in Vista where
other Microsoft platforms are behaving properly, in the same Mid-Tier
environment, Frederick has
pointed us to an item worth checking.
The exact mechanism by which Vista interprets this timestamp
differently from XP is not yet
known to me, and probably
] On Behalf Of Reiser, John J
Sent: Tuesday, May 01, 2007 8:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: timestamp question (set date and time)
Fred,
That looks good but you would have to use a REPLACE() to change the
12:00:00 AM to 5:00:00 PM and just leave off the +5:00:00 PM.
Dan,
Try experimenting
1 - 100 of 137 matches
Mail list logo
