nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert date to just number of the month

Hi all,

I have column with "date" date type field and the values there are for instance "DEC-20", "NOV-20".

I would like to change this column to the number of the month, e.g. "12", "11", ... .

Anyone has a simple solution to do so?

Alternatively, it it's easier to convert to the month number from the string, please say so. In my workflow I currently converted the string already to a date field. So both options are fine for me.

Really appreciate your help and many thanks in advance.

Have a nice day,

Christoph

Date Time

Accepted answers

Hi @ChristophVW ,

You can try using the DatetimeMonth() function which will return you the numeric value for a month in a date field.

So if your date field is called [Order Date] then the formula you should use is:

Tostring(Datetimemonth([Order Date]))

Hope that helps,

Angelos

All comments

Hi @ChristophVW ,

You can try using the DatetimeMonth() function which will return you the numeric value for a month in a date field.

So if your date field is called [Order Date] then the formula you should use is:

Tostring(Datetimemonth([Order Date]))

Hope that helps,

Angelos

Hello @ChristophVW ,

Have a look at the attached. Hopefully it will give you an idea.

Thank you very much @AngelosPachis ! Works like a charm.

Only did a very minor tweak from 'Tostring' to 'Tonumber' in my case, but visually the same.

How do I convert "16-JUN-01' to date format

Using a DateTime Tool:

The %b symbolizes the 3 letter word for Month, whereas %B is for the full name of the month.

Hope this helps.

That worked like a charm Thanks :)

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

MarqueeCrew 13710

apathetichell 13703