Change number to extensive week day

[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

 

[Douglas J. Steele]

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, ...

 

[Guest]

Exactly, DS!

Many Thanks for your help.
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, ...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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