AnsweredAssumed Answered

Calculate Day of the week from a variable

Question asked by carnicelli on Mar 27, 2014
Latest reply on Mar 27, 2014 by carnicelli

Title

Calculate Day of the week from a variable

Post

     I have an Advertising Media Placement layout in appendix which I use to inform the number of insertions by day/moth/year.

     I'd like to know how can I create calculation fields above the numbers 1 to 31 in order to calculate and bring just de first letter of the "day of the week" as  (S, M , T, W ,T, F, S)  Each time I update de field  Mês de Veiculação.

     I tried in this way creating a calculation for each day but the results are not  accurate

     DayOfWeek ( Date ( 2 ; Mês ( Período Veiculação ); Year ( Período Veiculação ) ) )

      

captura.png

Outcomes