Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 dudumoscona
		
			dudumoscona
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi all,
i have a module that in one PC the date field show correctly and in another PC/Machine show wrong .
Attached 2 of the results - how could it be ?
wrong
correct
 
					
				
		
 jerifortune
		
			jerifortune
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have formatted the date for you.
What I did:
Properties >> Number >> Override document Settings >> Date.
Hope this works for you.
 
					
				
		
 jerifortune
		
			jerifortune
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try formatting the date field using date function. Eg. Date(Finalized, 'm/d/yyyy')
I can see both systems are producing wrong date. You cannot have 56/10/2018 as date. Something might be wrong with the dataset.
 dudumoscona
		
			dudumoscona
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		still not working, the first one does show correct btw - you can see only valid dates there.
 tharanikannan
		
			tharanikannan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi ,
Please attach a sample data.
 dudumoscona
		
			dudumoscona
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 dudumoscona
		
			dudumoscona
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		i've attached sample data
 
					
				
		
 jerifortune
		
			jerifortune
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have formatted the date for you.
What I did:
Properties >> Number >> Override document Settings >> Date.
Hope this works for you.
