odure
(Odure)
1
Good day Friends - quick one,I have a formula I am trying to pass into an excel report to convert Months into Numbers.
=MONTH(DATEVALUE(B3&"1")) - this seems to work with Excel but when I input this in Studio - I keep getting an error - anyone experienced before.
Many thanks
Anil_G
(Anil Gorthi)
2
@odure
Did you add it like this
"=MONTH(DATEVALUE(B3&""1""))"
This is how you add the formula using write formula activity
cheers
1 Like
system
(system)
Closed
3
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.