using date within file path

[MacSig]

Hello folks,

I'm writing a script to export some files from a container field.

I need to order the exported files by a field called "manufacturing date" that has the format "mm/dd/yyyy" but because of the slashes FM doesn't create a folder called "mm/dd/yyyy" but three folders (one inside the other one) "mm" "dd" "yyyy" since it interprets the slashes as a path subfolder.

Is there a way to tell it that the field must use as is without

creating any subfolder?

Thanks and have a nice day!

Sig

[mr_vodka]

I dont recommend saving any files like that. You should instead save it with something like an underscore.

MM_DD_YYYY

[MacSig]

Thanks for your reply.

In the field the date is stored as "mm/dd/yyyy". How can I convert it to "mm_dd_yyyy"?

Thanks again.

Sig

[mr_vodka]

Right ( "0" & Month ( YourField ); 2 ) & "_" &

Right ( "0" & Day ( YourField ); 2 ) & "_" &

Year ( YourField )

[mr_vodka]

BTW, it may make sense to save it as YYYY_MM_DD especially if you plan on saving these files for longer than a year. It will sort better in your directory folder.

[MacSig]

thanks John, the year idea makes sense. I will go with it

Have a nice day

Sig

Edited September 16, 2008 by Guest