Name of the month

bluecox

Forums

Hello all,
Is there any quick method of getting the name of the month (using the Date field in the datasource) rather than writing a long formula with @if(@month(DATE) =1, "January" ... etc.
Regards
 

Steven Luciani Tue, 05/14/2019 - 07:04

Hello,

If you use the @compif function the formula will still be a bit long, but not as complicated meaning less brackets and constantly repeating @if. Remember you can save the equation and reuse it on other projects or on different files in the same project.

@compif(@month(DATE)=1, "January", @month(date)=2, "February") You would do this until December.

 

Steven Luciani Tue, 05/14/2019 - 07:07

Also, you can copy and paste in the equation editor so you can do the January portion:

@month(DATE)=1, "January",

then copy and paste it 11 more times and just change the month number and the month name. Less typing and you'll get the equation created more quickly.