<div>
personally, I'd advise against storing this value, as it can always be recomputed when you need it via a query.
</div>


personally, I'd advise against storing this value, as it can always be recomputed when you need it via a query.

<div>
Just use a textbox on your form bound to EndDate.<br />
Then set the Format property of the textbox to: <br />
<br />
&nbsp; yy\-mmm<br />
<br />
/gustav
</div>


Just use a textbox on your form bound to EndDate.
Then set the Format property of the textbox to:

  yy\-mmm

/gustav

<div>
<div class="content wysiwyg-content">
I have a date field [EndDate], I want to capture year and month and put them in a text field [RefPeriod] with the following text format yy-mmm<br />
<br />
Example: for 30-Nov-13 in EndDate, I would like to have 13-Nov in RefPeriod<br />
<br />
Thank you
</div>
</div>


I have a date field [EndDate], I want to capture year and month and put them in a text field [RefPeriod] with the following text format yy-mmm

Example: for 30-Nov-13 in EndDate, I would like to have 13-Nov in RefPeriod

Thank you

pulling string values form date field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.