Forum Discussion

GreggGregg's avatar
GreggGregg
Qrew Trainee
7 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 would convert the date field to just the name of the month i could combine them. Whats the formula for converting a date to a month?
App builders
  • RobIV's avatar
    RobIV
    Qrew Cadet
    7 years ago
    The simplest formula would just be 
    Month([userSelectedDate])
    This would return a number for the month and you could make your decisions based on that number.

    If you must have the text name of the month, use
    Case(Month ([userSelectedDate]), 1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December"))

    Hope this helps,

    ~Rob
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I'm not understanding why you don't just make a table report that Groups by month, but here is a formula for a formula text field type  which will convert a date to YYYYMM format.

    (not tested)

    ToText(Year([my date field]))
    &
    Right("0" & ToText(Month([My Date field])),2)
  • PaulVorster1's avatar
    PaulVorster1
    Qrew Cadet
    7 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