Get the month number from a date in Calculated Field

👨‍💻 Development Help
1

what could be the formula to get the month number out of the date

I tried this and did not work (I am new to Suite )
{p0} = Invoice Date

{m{P0}}

2

You can try…

{date(m;{P0})}

I’ve had trouble with date created and date modified trying to use date functions in the past. What did was create a date time field “created date” and make it equal to “date created” and then I could use created date in my formulas. Not sure if that’s the date you’re trying to extract, but if my formula suggestion does not work try populating a custom field and then using that in your date calc.

3

@pstevens Thanks for the quick response. I am looking for something like this:

if the invoice date = 2023-07-02

then field will capture 07 as the month.

4

For now i am using “{substring({P0}; 5; 2)}”

It works for my case .

5

That formula should work. Try it out.

6

it shows 122023-07-02 . This is the output when i try that formula

7

Weird? The documentation says that should output only the month of {P0}

1 Like
8

That DOES work when I tested in a workFlow here. - Suite 7.12.11.

You probably tried this - but for testing use a Text type field to save the result to - : so you can insert both the raw {P0} value and the function;
Field P0= {P0} and the date function output is {date(m;{P0})}

notice that anything that is not in { brackets will just show as text+spaces in the output - so I used explanatory text: ‘Field P0 =’ etc

1 Like
9

Will give it a try. I am using 8.x version not sure if anything changed