Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[carbo]

I have some problems with date fields of images taken at different time zones.
After some holidays, i have gathered pictures taken by all group members.
The problem is that not all of them have set correctly the time of their camera.
So in media center some pictures taken at the same time have dates seperated by 5 hours which mess all my sorting.

I have tried the expressions "=[Date]+300" or "=[Date]-300" but both of them remove 5 hours and i want to add 5 hours...

Any idea to fix my metada ?

Thanks,

Guillaume

[MrC]

Assuming 5 hours ahead...

   formatdate(math([date,0]+(5/24)), datetime)

Use subtraction to adjust 5 hours behind.

[carbo]

Thanks for the quick answer but unfortunately your expression doesn't seem to work.
When I try it, the date returned is blank

Any idea why ?

[MrC]

Create an expression column in a pane, and enter exactly the expression shown.  Does that work?  Works here.

The minutes portion will be off by up to about 4 minutes for times late in the day, due to round off error.

[carbo]

It's not working for me 
All my files have "unassigned" value except the one with the date "2011"

I wonder if the problem comes from my locale where the date format is "DD/MM/YYYY HH:MM:SS"

[MrC]

What are the values of [Date] for the files in question?  Show that column.

[carbo]

Here is the screenshot

[MrC]

If you look at the raw date values, you should see they look like those shown in the screenshot.  The expression column is: [Date,0].  These are just floating point numbers.  MC does date conversion upon display, so your dates will be expressed in the locale's format, and locale should not affect the internal value of the date.

Possibly when you tried to assign the date field

  "=[Date]+300" or "=[Date]-300"

you modified the type from a floating point to a string.

[Lasse_Lus]

math(function) and decimals in MC needs "dots"

does this work ?

formatdate(math(replace([date,0],/,,.)+0.208333),datetime)

[MrC]

No dots required.

[Lasse_Lus]

but C, your system is set to use dots is it not ?, my is ","

[carbo]

Lasse is right ! with the replacement of , by . the expression now works !
It may be a bug of the math expression ?

Anyway thanks for the both of you, my problem is resolved !

[MrC]

This is a little disturbing, but good to know.

Perhaps the Math() entry for the expression page in the wiki should be updated to indicate that for locales that do not use dot as a decimal, the workaround is required.

[Matt]

Lasse is right ! with the replacement of , by . the expression now works !

The math parser supports functions, where parameters are delimited by commas.  This means it's pretty tough to allow a comma to be the decimal.

For example, imagine:
Math(min(1.2,2.21))

Now rewrite it using commas instead, and you'll see what a mess it would be for a parser:
Math(min(1,2,2,21))