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 woul...
App builders
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)