Forum Discussion

RafaBitencort's avatar
RafaBitencort
Regular Visitor
8 years ago
Solved

FORMAT() returns semester Number

hello,

 

I need to return the semester/year from a date. 

 

Thaks for help.

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    YEAR will return the year. Define semester. How many weeks are in your semester? 15, 18? When does the first semester start? January 1st, some other date?

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    YEAR will return the year. Define semester. How many weeks are in your semester? 15, 18? When does the first semester start? January 1st, some other date?

  • Seward12533's avatar
    Seward12533
    Icon for Solution Sage rankSolution Sage
    8 years ago

    If you have a date table you can add a Semester column to the table and then use relationships to determine semester from any date.