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:
답변 4개
Hello @Michelle Alexander
Just try below one and see if it's works -
PARSEDATE(LEFT(csv['creation_time'],10),'yyyy-MM-dd')