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

Question

Question

get month and year from date field

Forms Version 11
Updated June 28, 2023
asked on June 27, 2023

Hello,

I have the following formula:

=MONTH(TEXT(Date_of_Inspection)) & "/" & YEAR(TEXT(Date_of_Inspection))

where Date_of_Inspection is a date field on the form defaulted to today's date.

Formula works and the output is M/YYYY, e.g. 6/2023 but I would like for the output to be JUNE 2023.

Tried

Any help is much appreciated!

On Forms v11.0.2 

0 0

Answer

SELECTED ANSWER
replied on June 28, 2023

Try the "Choose" function

=CHOOSE(MONTH(TEXT(Date_of_Inspection)),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") & "/" & YEAR(TEXT(Date_of_Inspection))

 

3 0
replied on June 28, 2023

Thank you! Worked perfectly! Have a good day! smiley

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...