Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
COURSE of the MONTH
13 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
pulling string values form date field
Posted on 2013-12-17
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
Example: for 30-Nov-13 in EndDate, I would like to have 13-Nov in RefPeriod
Thank you
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
It should be:
Format([EndDate],"yy-mmm")
I would probably add it to the underlying record source for your form and then set the control source of [RefPeriod] to whatever you call the column in the record source.
Edit - you could also just add it directly to the control source as capricorn suggests.
Format([EndDate],"yy-mmm")
I would probably add it to the underlying record source for your form and then set the control source of [RefPeriod] to whatever you call the column in the record source.
Edit - you could also just add it directly to the control source as capricorn suggests.
Active today
personally, I'd advise against storing this value, as it can always be recomputed when you need it via a query.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month13 days, 14 hours left to enroll
800 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.