- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 07:14 AM
Hi Everyone!
So I would like a formula field where it shows the month and year of the End Date match the month and year today, say "This Month". I only know month and year separately as shown below however, I want them together in a single-sentence formula.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 08:13 AM
That would be the same formula, just changing the month-checking field from "END Date" to "1st Payment Date" :

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 07:44 AM
Yvia, try this formula:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 08:04 AM
Thanks, Ron!
How about if I want to have month and year in single sentence formula for 1st payment?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 08:13 AM
That would be the same formula, just changing the month-checking field from "END Date" to "1st Payment Date" :
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2023 08:16 AM
Thanks Ron!
