Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello,
Is it possible to convert a YYYY-WW date format into a single date? Lets say the last day of that week?
 kaushiknsolanki
		
			kaushiknsolanki
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Ralf,
.
you are also right.
Better you use the solusion i have suggested with checking the lenth, you can also try the solution given by Ori.
Regards,
Kaushik Solanki
 
					
				
		
 jagan
		
			jagan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Try like this
=MakeWeekDate(left('2013-02',4), Num(SubField('2013-02', '-', 2)))
Regards,
Jagan.
 rbecher
		
			rbecher
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Or subfield:
=MakeWeekDate(subfield('2013-2','-',1),subfield('2013-2','-',2),0)
