cbhiii cbhiii

## IFTTTDate.md

      
        
          
            
              
              1 file
            
          
          
            
              
              8 forks
            
          
          
            
              
              29 comments
            
          
          
            
              
              73 stars
            
          
        
        
          
              
          
          
            
                oscarmorrison
                / IFTTTDate.md
            
            
              Last active
              December 3, 2023 21:44
            
              
                Make IFTTT Date Format play nice with Google Spreadsheets 
              
          
        
      
        
  
      
    ##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))

##Time