Calculate Day of the week from a variable
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 ) ) )