Question

Get Month Value in Laserfiche Forms

Version 12 Forms

Updated February 13

asked on February 11

I'm able to get the Month value in digits format using this formula

=MONTH(Date). Using that it spits out "2"

What I am trying to do is get the month name based off the digit or if there is another way to do this straight from forms. that would be ideal.

thank you for your help!

0 0

Replies

replied on February 11

To make this simpler, I'd use the CHOOSE function. The Month(TODAY()) value returned ie: 2 which acts as the index value to pull from the list of values provided in that order, just add all the months in Order.

Example

=CHOOSE(MONTH(TODAY()),"January","February","March")

the Month value of 2 returns February

3 0

replied on February 11

I think I was able to get it using info from another post a couple years back.

If there is a better, simpler way. by all means please let me know. It works for todays current month. but I want to test and make sure that it will work for the future months to come, we'll see 👀

=IF(MONTH(TODAY()) = 1, "January", IF(MONTH(TODAY()) = 2, "February", IF(MONTH(TODAY()) = 3, "March", IF(MONTH(TODAY()) = 4, "April", IF(MONTH(TODAY()) = 5, "May", IF(MONTH(TODAY()) = 6, "June", IF(MONTH(TODAY()) = 7, "July", IF(MONTH(TODAY()) = 8, "August", IF(MONTH(TODAY()) = 9, "September", IF(MONTH(TODAY()) = 10, "October", IF(MONTH(TODAY()) = 11, "November", IF(MONTH(TODAY()) = 12, "December", ""))))))))))))

0 0

replied on February 13

This was covered in this post - https://answers.laserfiche.com/questions/125418/Forms-Date-Formatting-via-TEXT-Formula#226186

It seems that in cloud the TEXT function works as expected but not on premise as it doesn't handle the formatting parameter. In theory it should be as simple as =TEXT(<variable>,"mmmm") but it just gives me a number of parameters error.

0 0

replied on February 13

TEXT in cloud doesn't support this option to set formatting as you would in excel, etc. We've been asking for it for years.

0 0

You are not allowed to follow up in this post.

Question

Question

Get Month Value in Laserfiche Forms

Replies

Sign in to reply to this post.