Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
i am having a field monthyear which shows 201302 yearmonth
by using this field i have to create week numbers
can anyone help me
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Try like this
=Week(MakeDate(Left(YearMonth), Right(2)))
Hope this helps you.
Regards,
Jagan.
 
					
				
		
it is not working
i am using this
WeekName([ Date], 0, -1) as Week,
by this i am getting the week numbers and year but i need only week numbers year should not be shown
