Forum Discussion

GreggGregg's avatar
GreggGregg
Qrew Trainee
6 years ago

I need a field that takes the date field and shows only the month. Formula?

Every record has a date that is selected by the user. I need to combine all records within a current month to get totals. I dont want to use a summary table, so if I had a formula date field that woul...
App builders
PaulVorster1's avatar
PaulVorster1
Qrew Cadet
6 years ago
H there, I am currently using the formula for my month field, which combines the date and month. Just another alternative to the two solutions above.

var date DateWords = [Project CAC Date];var text Month = Case(Month($DateWords),
1, "10 January",
2, "11 February",
3, "12 March",
4, "1 April",
5, "2 May",
6, "3 June",
7, "4 July",
8,"5 August",
9,"6 September",
10,"7 October",
11,"8 November",
12,"9 December");

$Month