INTERACT FORUM

More => Old Versions => JRiver Media Center 24 for Windows => Topic started by: dhiggins on May 24, 2018, 08:13:39 am

Title: FormatDate function error
Post by: dhiggins on May 24, 2018, 08:13:39 am

I'm having an issue with the FormatDate function.

I've attached a screenshot showing the issue.

Basically, I use formatDate([Date], %m) and it's always coming back "01"

On the other hand, if I use [Month], it resolves to the correct Month name.

I've tried "%m", "%M", "MM", "mm" etc, nothing appears to work to actually return the month number as "xx"

Any ideas?

This is MC 24.0.7 64bit

Title: Re: FormatDate function error
Post by: dhiggins on May 24, 2018, 08:19:15 am

Well, may have solved my own issue, or at least worked around it.

If I use FormatDate(MM) it seems to work correctly.

Maybe just a problem with specifying the date to use?

Title: Re: FormatDate function error
Post by: ferday on May 24, 2018, 08:21:41 am

Try [date,0] in the original function

Title: Re: FormatDate function error
Post by: Hendrik on May 24, 2018, 08:22:00 am

You need to use [Date,0] to pass the raw unformated date value to the FormatDate function, ie. FormatDate([Date,0], %m) should work