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

    Datefield format for path calculation

    jandavid

      Hello,

       

      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!

       

      J