Set date format dd/mm/yy

RT Users
1

Hi,

I was wondering if anyone know how to set a RT Config for date format
“dd/mm/yy”. So far this is my configuration;

Set($DateTimeFormat, { Format => ‘ISO’, Seconds => 0 });
Set($DateDayBeforeMonth , 1);

Unfortunately the output I get from this format is:
→ 2014-04-07 11:44

Any Ideas ?

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138.html

2

  1. Seriously forget about it and embrace ISO 8601 everywhere. :wink:

    Users will get used to it pretty quickly.

    ISO 8601 - Wikipedia

    This date format is unambiguous, doesn’t require lots of horrible
    awkward code to represent different date formats, and means no more
    embarrassing date screwups with customers and suppliers, and confusions
    because we can’t agree how to write dates in different countries.

    • It sorts naturally in log files and etc, which is an added bonus.

  2. Profit.

  3. Do something more interesting :slight_smile:

Hi,

I was wondering if anyone know how to set a RT Config for date format
“dd/mm/yy”. So far this is my configuration;

Set($DateTimeFormat, { Format =>> ‘ISO’, Seconds => 0 });

Set($DateDayBeforeMonth , 1);

Unfortunately the output I get from this format is:
->> 2014-04-07 11:44

Any Ideas ?

Rob Lister
rob@lonap.net
LONAP Ltd
+44 20 3137 8330

3

Is there a specific way to pass ISO 8601 as argument to Formula?

Thanks.

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138p57144.html

4

Thanks Rob.

Do you think there’s a way around this?

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138p57145.html

5

Hi,

I was wondering if anyone know how to set a RT Config for date format
“dd/mm/yy”. So far this is my configuration;

if you really want this, use:

Set($DateTimeFormat, {
Format => ‘LocalizedDateTime’,
Date => 1,
Time => 0,
DateFormat => ‘date_format_short’
},
);

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

6

Thanks Emml - it works.

Quick one!
I have tried to activate the time without the seconds like this:

Set($DateTimeFormat, {
Format => ‘LocalizedDateTime’,
Date => 1,
Time => 1,
DateFormat => ‘date_format_short’,
Seconds => 0
},
);

The seconds doesn’t seem to turn off. Is it possible to achieve this?

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138p57153.html

7

Thanks Emml - it works.

Quick one!
I have tried to activate the time without the seconds like this:

Set($DateTimeFormat, {
Format => ‘LocalizedDateTime’,
Date => 1,
Time => 1,
DateFormat => ‘date_format_short’,
Seconds => 0
},
);

The seconds doesn’t seem to turn off. Is it possible to achieve this?

See perldoc DateTime::Locale:

TimeFormat => ‘time_format_short’

should be ok for you.

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

8

You’re a star Emml.

Lastly, I just realised the date output is 4/8/14 3:23. Can I swap the
mm/dd around to be dd/mm ?

Also can I change the time to 24hr instead of stating AM & PM i.e is
possible to pass prefers_24_hour_time as argument ?

Many Thanks

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138p57157.html

9

You’re a star Emml.

One more bother. I just realised the date output is 4/8/14 3:23. Can I
swap the mm/dd around to be dd/mm ?

View this message in context: http://requesttracker.8502.n7.nabble.com/Set-date-format-dd-mm-yy-tp57138p57156.html

10

What file do I edit it order to change the date format.

This is exactly what we want as well.-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Emmanuel Lacour
Sent: Tuesday, April 08, 2014 3:43 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Set date format dd/mm/yy

On Mon, Apr 07, 2014 at 12:14:25PM -0700, losintikfos wrote:

Hi,

I was wondering if anyone know how to set a RT Config for date format
“dd/mm/yy”. So far this is my configuration;

if you really want this, use:

Set($DateTimeFormat, {
Format => ‘LocalizedDateTime’,
Date => 1,
Time => 0,
DateFormat => ‘date_format_short’
},
);

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com
RT Training - Dallas May 20-21
http://bestpractical.com/training

11

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On 4/23/14, 4:34 PM, Raymond Corbett wrote:

What file do I edit it order to change the date format.

This is exactly what we want as well.

RT_SiteConfig.pm

Best,

  • –Glenn

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlNYmVUACgkQf5MxTDXTimGpiwCgixF6bFD34r8v8mJIM18FzTxq
rjAAoIyUaD0RA3hHGPaIP2p1aSTSz77m
=Va/y
-----END PGP SIGNATURE-----

12

I edited our RT_SiteConfig.pm file, adding the following:

Set($DateTimeFormat, {
Format => ‘LocalizedDateTime’,
Date => 1,
Time => 0,
DateFormat => ‘date_format_short’
},
);

In the hopes of not displaying the time in the due date field.

But I am still getting:

Thu Jun 05 00:00:00 2014

Have I done something wrong?