INTERACT FORUM

Windows => JRiver Media Center 33 for Windows => Topic started by: MusicBringer on January 05, 2025, 09:43:08 am

Title: Rename, Move, & Copy Files - [Date] help please
Post by: MusicBringer on January 05, 2025, 09:43:08 am

Rename, Move, & Copy Files

Filename
Rule : [Date]
gives me horrid underscore separators such as 05_01_2025

How can I specify my chosen Date Format please.
Such as 5 Jan 2025, or perhaps 20250105
Thank you,

Title: Re: Rename, Move, & Copy Files - [Date] help please
Post by: Matt on January 05, 2025, 09:59:12 am

Check out FormatDate(…):
https://wiki.jriver.com/index.php/Date_and_Time_Functions

Title: Re: Rename, Move, & Copy Files - [Date] help please
Post by: MusicBringer on January 05, 2025, 10:49:57 am

Hello Matt,
thanks for the pointer.
Sorry to say my head does not understand the IT jargon on that page.
I simply require a [Date] without underscores please, even spaces instead of horrid underscores will do.
thanks,

Title: Re: Rename, Move, & Copy Files - [Date] help please
Post by: Richard Martin on January 05, 2025, 11:28:48 am

You will need something like
=formatdate([date modified,0], dd MMM yyyy), replace date modified with whichever date field you need.

Title: Re: Rename, Move, & Copy Files - [Date] help please
Post by: MusicBringer on January 05, 2025, 12:07:44 pm

Thank you Richard, that'll do nicely
😊