INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: Cmagic on January 23, 2007, 03:45:36 am

Title: Formating time
Post by: Cmagic on January 23, 2007, 03:45:36 am

Hi,

Is there a way to format the time of the day from a date field with the formatDate() function ?
I tried using hhmmss etc.. without any success.

I'm trying to build a custom field that would output something like 20070123-1230 (yyyyMMdd-hhmm) for pictures.

Thanks for any help,

Christian

Title: Re: Formating time
Post by: marko on January 23, 2007, 03:59:15 am

How is your [date (filename friendly)] field formatted?

Mine are filled like so: yyyymmdd-hhmmss, so, a custom library field using calculated data from the following template would produce the data you require:

mid([date (filename friendly)],0,13)

Close enough?

-marko.

Title: Re: Formating time
Post by: Cmagic on January 23, 2007, 06:45:23 am

Hi Marko,

You're smart ! That did the trick thanks.
Anyway formating time directly might be useful in some cases.

Again thanks for the smart thinking,

Christian