You are viewing limited content. For full access, please sign in.

Question

Question

Get End of Month

asked on April 12, 2018 Show version history

I am wanting to get the end of the month date and the end of month date for the following month.

Ex:  It's 4/12,  Need 4/30, and 5/31.

 

Would I first need to get the current date month: 

%(RetrieveFieldValues_Date of Service#"MM"#) and +1, +2 to it respectively and then use the Date Token Calculator to subtract 1 from the first day? 

Ex: 05/01 - 1, and 06/01 - 1 

Or is there an EOMONTH function I would be able to use to make this a little less cluttered?

1 0

Answer

SELECTED ANSWER
replied on April 12, 2018 Show version history

EOMONTH(%(Date),0 )  and EOMONTH(%(Date),1 ) in Token Calculator will do it. The function is named RoundMonth in the list.

3 0

Replies

replied on April 12, 2018

Thanks a ton!  I wasn't sure if it would since I couldn't find that within the Laserfiche Admin Guide in Token Functions.  

Is there a list of other functions that may not be listed in there like the EOMONTH?

 

0 0
replied on April 12, 2018

There are no hidden functions. EOMONTH is listed as "RoundMonth" in the Token Calculator's list.

The list of functions available through the Token Editor is a lot more limited. EOMONTH cannot be used there.

1 0
replied on April 12, 2018

Thank you much.  That link is what I needed.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.