Unanswered

formatdatetime(utcnow() ,'M') = 13 January

(0) Share

Report

Posted on by PR-13010923-0

Everywhere I looked 'M' means one digit month but when I use it in scrip I get DD MMMM (e.g. 13 January). If I use 'MM' it becomes 01 as it should. What is going on?

Pontus

Categories:

Building flows

formatdatetime.JPG

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

eetuRobo 4,190 Super User 2025 Season 2 on at

Like (1)

Report

I think that is how it should work in .NET even thought it feels unintuitive

https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (1)

Report

Hi @PR-13010923-0,

In addition to the link shared by @eetuRobo there is another link which might be useful.

The custom date and time format strings article:

https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

That article has examples for the formats you are using.

Was this reply helpful? Yes No