Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[dhiggins]

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

[dhiggins]

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?

[ferday]

Try [date,0] in the original function

[Hendrik]

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