Name of the month

4 posts / 0 new
Log in or register to post comments
Last post
Tue, 05/14/2019 - 05:44
#1
bluecox
Offline
Joined: 10/17/2018 - 05:33
Name of the month

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
 

Top
Tue, 05/14/2019 - 07:04
Steven Luciani
Offline
Joined: 07/31/2012 - 13:20

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.

 

Top
Tue, 05/14/2019 - 07:07
Steven Luciani
Offline
Joined: 07/31/2012 - 13:20

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.

 

 

Top
Tue, 05/14/2019 - 08:36
bluecox
Offline
Joined: 10/17/2018 - 05:33

Thank you Steven , this is definitely less typing that my original formula

Top