How to Set Sr. No 1 in each month of attendance.

Question

Hi how to gererate sr no starting from 1 when each Month Change or each financial year change means(1-4-17 to 31-3-18). in sql or c#

Tapan Patel · Answer

SELECT DateCol  CASE WHEN MONTH ( DateCol )>3 THEN MONTH (DateCol)-3 ELSE MONTH ( DateCol )+(3*3) END [Series] FROM #Table ORDER BY DateCol Desc

Ankit Sharma · Answer

Hi Nilesh Please try this code and let me know. string date = 1-4-17 ; if (Convert.ToInt32(date.Split( '-' )[0])==1) { int sr_no = 1; } Hope this helps