Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 khadar
		
			khadar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Team,
I need a small on how to create a logic to develop buttons for lastweek & Current week.
when user click on lastweek button whole lastweek start from monday to sunday all dates should get selected and data has to be updated as per those dates,
similry for currentweek button too.
 
					
				
		
 durgesh22
		
			durgesh22
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .
 
					
				
		
 durgesh22
		
			durgesh22
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try below, it should work
Current week Button--
Action-- Select Value Matching search Criteria
Field--Date field
Value-- ='>=$(=WeekStart(today()))<=$(=today())'
Last week Button--
Action-- Select Value Matching search Criteria
Field--Date field
='>=$(=WeekStart(today(),-1))<=$(=Weekend(today(),-1))'
 
					
				
		
 durgesh22
		
			durgesh22
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Add one more action of clearing selection in field before select value action for each button
 khadar
		
			khadar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Durgesh,
Thank you for helping me. I tried above result is getting in number format like37581of 38034.
and for we weekstart function in not working in front end
 
					
				
		
 durgesh22
		
			durgesh22
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .
 khadar
		
			khadar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you so much for you help Durgesh. This logic worked for me a lot
