Listers ~ I want to push a date field to be formatted as "MM/DD/YY". Is
there a quick way to do this?

O/S: Win2K
Database: Oracle 8.1.6.3
User/Admin: Completely customized ARS 4.05.02
ARServer 4.05.02 (patch 1077)

Laurie Muhlethaler
G
Senior Remedy Administrator
(415) 878-5060



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
Remember that the D/T string is stored as an integer. How it is displayed on any given client is dependent on how the regional settings are set for the date format on that client. Date fields are still storing the D/T integer string, but they only display the date portion of it.

Rick



From: Muhlethaler, Laurie - GPM
Sent: Fri 7/1/2005 3:54 PM
To: arslist@ARSLIST.ORG
Subject: Format date only field


Listers ~ I want to push a date field to be formatted as "MM/DD/YY". Is
there a quick way to do this?

O/S: Win2K
Database: Oracle 8.1.6.3
User/Admin: Completely customized ARS 4.05.02
ARServer 4.05.02 (patch 1077)

Laurie Muhlethaler
G
Senior Remedy Administrator
(415) 878-5060



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web interface

Laurie:
There is nothing you can do during a push field.

Date and date/time fields are always stored as integer
internally(number of seconds since jan 1, 1970). How
it is displayed is decided at the time the client
(Remedy User) shows the date. See
Tools->Options->Locale->Date/Time Style in Remedy
User.





--- "Muhlethaler, Laurie - GPM"
wrote:

> Listers ~ I want to push a date field to be
> formatted as "MM/DD/YY". Is
> there a quick way to do this?
>
> O/S: Win2K
> Database: Oracle 8.1.6.3
> User/Admin: Completely customized ARS 4.05.02
> ARServer 4.05.02 (patch 1077)
>
> Laurie Muhlethaler
> G
> Senior Remedy Administrator
> (415) 878-5060
>
>
>

> UNSUBSCRIBE or access ARSlist Archives at
> http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Laurie,

The answer would depend on the target of the push. If you're pushing to
a character field, you could do a set fields first -- concatenating the
month, day, and year components -- and create a formatted string. Then
you could push the value of the local character field to a character
field on the target form.

But yeah... If you're talking about pushing a date/time field value to
another date/time field, what Rabi said is spot on.

--Tim

Rabi Tripathi wrote:
> Laurie:
> There is nothing you can do during a push field.
>
> Date and date/time fields are always stored as integer
> internally(number of seconds since jan 1, 1970). How
> it is displayed is decided at the time the client
> (Remedy User) shows the date. See
> Tools->Options->Locale->Date/Time Style in Remedy
> User.
>
>
>
>
>
> --- "Muhlethaler, Laurie - GPM"
> wrote:
>
>
>>Listers ~ I want to push a date field to be
>>formatted as "MM/DD/YY". Is
>>there a quick way to do this?
>>
>>O/S: Win2K
>>Database: Oracle 8.1.6.3
>>User/Admin: Completely customized ARS 4.05.02
>>ARServer 4.05.02 (patch 1077)
>>
>> Laurie Muhlethaler
>> G
>> Senior Remedy Administrator
>>(415) 878-5060
>>
>>
>>
>
>
>
>>UNSUBSCRIBE or access ARSlist Archives at
>>http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>
>
>
>
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)