12 Replies Latest reply: Apr 14, 2011 7:00 AM by Deepak Vadithala RSS

    New "Day of the Week" field

    Gerhard Laubscher

      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