Get start and end date of the current and last semester of the calendar year

okat
Posts: 14
Joined: Tue Apr 18, 2017 4:04 am

Get start and end date of the current and last semester of the calendar year

Postby okat » Sun Feb 11, 2018 9:27 am

From an X date, I am interested in finding ("M") the starting and ending date of the current semester and the starting and ending date of the previous semester, of the calendar year. For example, today is 10/02/2018. Start current semester = 01/01/2018, date of completion of the current semester = 30/06/2018, start date of last semester = 01/07/2017, last semester's final date = 31/12/2017.
Thank you.

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 4 guests

cron