calculate quarter

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi all,

On a form, I have a text box named "CaseDate" which is a
short date (input mask: 99/99/0000;0;_). I would like to
determine what the quarter is after the user enters the
date. As in, placing code in the AfterUpdate event in the
CaseDate field and having another text box on the form
named "CaseQuarter" updated after the user enters the case
date.

I have tried many versions of
(Format([Me.CaseReviewDate], "q"))
but am not getting anything to work.

Thanks for any assistance!
 
(Format([Me.CaseReviewDate], "q"))

The above is a correct syntax/statement, provided CaseReviewDate returns a
Date.

? format(date, "q")
2

have you tried to convert CaseReviewDate to a datetype like in
Format(CDate([Me.CaseReviewDate]), "q"))

Kindly repost, if this doesn't remedy

Krgrds,
Perry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry Form 3
Input Mask 1
Date Mask auto changes 1916 to 2016 2
How to validate a date entered on a form 2
Date 4
Input Mask 2
Date Input Mask and Value 2
Problem with form and coding 10

Back
Top