1 Reply Latest reply on Oct 21, 2015 1:56 AM by erolst

    Datefield format for path calculation




      I am storing media files in containers configured as open storage by calculating a path relative to the database based on two fields, a title field and a date field. 


      The calculation is simply this:

      Date & "/" & Title & "/"

      (The "Date" is a field not a date, and that field is formatted as a date).

      Now the actual folder structure that I get is:

      Database > Day > Month > Year > Title > File.mov


      How do I get the date field not to split up into Day, Month, and Year

      (also: why the weird ordering of Day and Month above year in the hierarchy ??)

      and instead as just one folder YYYY-MM-DD (which is the format that the field is in and also the format that I set my OS to).


      Is there some command like AppleScripts "as text" to treat the date field as text for the sake of path calculation? 


      Help greatly appreciated!