WeekdayName

[Ukraine82]

I'm would like to use WeekdayName function that returns the day of the week.

Formula:
WeekdayName (number)
number is a value from 1 to 7, representing a day of the week

Is there a way I can use the WeekdayName function with my date field that will give me the name of the day?

Example:
WeekdayName ([Date Refd]), the result I'm getting is #Error.

Thanks,
Michael

 

[shadow9449]

Michael:

Looks like you are using the function correctly.

How are you using it? Maybe the problem is somewhere else.

SHADOW

 

[Ukraine82]

I have a separate field called Date Refd, but I would like to make an expr field that will give the name of the weekday from date refd field.

Date Refd = 1/10/05
Monday

If I use the WeekdayName(2)

It will show me Monday, but I don't want to use the numbers for each Date Refd record.

I'm looking for WeekdayName([Date Refd]) kind of thing. WeekdayName captures the date from Date Refd and gives me the name.

hth,
Michael

 

[Mile-O]

Why not just use this?

Format(Date(), "dddd")

 

[Mile-O]

Although:

WeekdayName(WeekDay([Date Refd]))

 

[Ukraine82]

SJ,

You are the man.

Thanks,
Michael