calculate quarter

[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!

 

[Perry]

(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