Change number to extensive week day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello!

I have a textbox were return us the number week day of the determined date.
Now, I would like to obtain that value for extensive (in another textbox the
corresponding word).

Something it type:
=IIf([Textbox1]=7;"SAT";Or[Textbox1]=1;"SUN";......)

Thanks in advance.
an
 
Assuming you mean you want to know the day in text, simply use the Format
function on the original date.

Format(MyDate, "ddd") will return Sun, Mon, Tue, ...
Format(MyDate, "dddd") will return Sunday, Monday, Tuesday, ...
 
Exactly, DS!

Many Thanks for your help.
an

Douglas J. Steele said:
Assuming you mean you want to know the day in text, simply use the Format
function on the original date.

Format(MyDate, "ddd") will return Sun, Mon, Tue, ...
Format(MyDate, "dddd") will return Sunday, Monday, Tuesday, ...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



an said:
Hello!

I have a textbox were return us the number week day of the determined
date.
Now, I would like to obtain that value for extensive (in another textbox
the
corresponding word).

Something it type:
=IIf([Textbox1]=7;"SAT";Or[Textbox1]=1;"SUN";......)

Thanks in advance.
an
Click to expand...
Click to expand...
 
Back
Top