Print

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

[leoric]

I want my photos to have naming scheme "yy-MM-dd hh-mm-ss". But I'm unable to do this easily because:
1. It is not possible to pass "Second" as 2nd parameter to FormatDate
2. It is not possible to specify "hh-mm-ss" part of flexible formating pattern

Please implement at least one of the items or advise if I miss something.

[marko]

It's been asked a few times, but so far, "Time" is not possible via formatdate().

hh-mm-ss are available from the [Date (Filename Friendly)] field, so you could create a new calculated data field using something like so:

mid([Date (Filename Friendly)],0,4)-mid([Date (Filename Friendly)],4,2)-mid([Date (Filename Friendly)],6,2) mid([Date (Filename Friendly)],9,2)-mid([Date (Filename Friendly)],11,2)-mid([Date (Filename Friendly)],13,2)

Will give you: yyyy-mm-dd hh-mm-ss

If you prefer, you could create two custom fields, one for the date, and one for the time, and then use them as you wish in your naming templates:

Date: mid([Date (Filename Friendly)],0,4)-mid([Date (Filename Friendly)],4,2)-mid([Date (Filename Friendly)],6,2)
Returns: yyyy-mm-dd

Time: mid([Date (Filename Friendly)],9,2)-mid([Date (Filename Friendly)],11,2)-mid([Date (Filename Friendly)],13,2)
Returns: hh-mm-ss

regards,
-marko

[leoric]

Thanks marko.
Actually I recollect this pattern, I used it some time ago with MC13. But recently I've noticed that FormatDate is able to handle hours and minutes (by passing Hour or Minute as second parameter) so I'm wondering why seconds and hh-mm-ss are not handled.