Skip to main content

Can anyone translate this into a usable date for the day field?  

2026-02-05T17:44:28.265Z 

 

Just a few of the things I've tried:

  • changing the formatting in the preview to different syntaxs like dd-MM-yyyy'T'HH:mm:ss.SSS'Z'
  • PARSEDATE((SUBSTITUTE(csv['creation_time'],'T',' ')),'dd-MM-yyyy HH:mm:ss.SSS')
  • PARSEDATE(SUBSTITUTE(csv['creation_time'],'T',' '),'dd-MM-yyyy HH:mm:ss.SSS z')
  • PARSEDATE(csv['creation_time'],'dd-MM-yyyy'T'HH:mm:ss.SSS z')
  • PARSEDATE((LEFT(csv['creation_time'],10)),'yyyy-MM-dd')
  • PARSEDATE(orig-date,yyyy-MM-dd) 

    var orig-date = LEFT(csv['creation_time'],10);

Those have all passed validation,  but then when I run a evalution, I get a message like this: 

Help with format date formula

 

 

 

 

 

  •  

     

     

4 respostas
  1. 6 de mar., 18:00

    Hello @Michelle Alexander

     

     

    Just try below one and see if it's works - 

     

    PARSEDATE(LEFT(csv['creation_time'],10),'yyyy-MM-dd') 

     

     

0/9000