hi there everyone,
I've been working on a creative use of %file_create_date% to determine when the media was added to the collection but it seems I'm going through a lot of steps and am looking for suggestions to maybe do a one-pass.
(background info, using minimserver, kinsky, Linn DS)
I'm using Guess Values "%_file_create_date%": %month_added%/%day_added%/%year_added% to create tags for each value so I can sort down quickly by year or month.
I also copy %file_create_date% into a tag called %create_date% and in minimum server use "-create_date" index tag for a reverse lookup which provides a good overview of all import dates.
problems encountered, the index comes up in raw %file_create_date% format which is mm/dd/year and really should be year/mm/dd for the index to work nicely.
I tried using a few functions to achieve the reformat and force leading zeros on month and day
format value: %create_date%": %year_added%/$num(%month_added%,2)/$num(%month_added%,2) <_this didn't work
so far for the easy approach
then I tried using some string formatting (right, left) but because of the single or double digits this would not work as well.
It seems I am not understanding which functions work on which action types, or I am just making some essential typo errors.
could anyone point me in the right direction?