New "Day of the Week" field

[gerhardl]

Hi,

I currently have a field in my table called [Effective Date].

I would like to add a new field called [Effective Day], where:

2011/04/11 = Monday

2011/04/12 = Tuesday, etc.

This way I can break my marketing report down to specific days of the week, as opposed to just dates.

My scripts currently contains this:

DATE(DATE#( [Effective Date], 'DD-MMM-YY')) as [Effective Date],

Thanks,

Gerhard

[gerhardl]

Hi Guys,

I just used the following and it seems to work fine:

DATE(DATE#( [Effective Date], 'DD-MMM-YY')) as [Effective Date],
weekday(DATE(DATE#( [Effective Date], 'DD-MMM-YY'))) as [Effective Day],

Thanks,

G

[#3]

OK i found something.

Miguel Angel Baeyens: "Actually, manual/help is wrong when it says it returns an integer (indeed, returns the short day name following the variable "DayNames" at the beggining of your script).

i thought this will return integers. Seems its not.
Why they didnt change it in help. it should be

weekday( date )

Week day. Returns a $(DayNames)

right?

[IAMDV]

Yes, that's what I meant in my previous post. Sorry for not being very clear. Thanks for the update on the Manual/help information, which is very useful.

Cheers!