Platform: Enolytics DTC

Summary:

What it is: Membership Year Month Sort contains integer values in YYYYMM format (like 202401 for January 2024) that enable proper chronological sorting of wine club membership data by month and year.

How to use it:
• Sort membership trends chronologically in reports and charts — unlike text-based date fields, these integers sort correctly because December 2023 (202312) properly comes before January 2024 (202401)
• Track club membership patterns over time by filtering to specific year-month periods or date ranges using these numeric values

Tip: Use this field instead of text-based month fields when you need accurate time-series analysis — string formats like "2024-1" don't sort properly because single-digit months get misordered.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Quick Stats:

An integer year-month value in YYYYMM format (e.g., 202401) for correct chronological sorting. String year-month fields like YYYY-M don't sort correctly because single-digit months are misordered.

Type: int