Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
5 years ago
Solved

convert Timestamp

Hi,   I have in my file a colomn with TimeStamps like this.     as you see the date is a mix of 8 digits, 9 digits or 10 digits.   I want try to make colomn`s Date & Time Colomnn  How c...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Frixel Try the following:

     

    Date Column = 
    VAR __Date = SUBSTITUTE(LEFT([Column1],SEARCH(" ",[Column1],,0)),"(","")
    VAR __FirstHyphen = SEARCH("-",__Date,,0)
    VAR __SecondHyphen = SEARCH("-",__Date,__FirstHyphen+1,0)
    VAR __Day = LEFT(__Date,SEARCH("-",__Date,,0)-1)
    VAR __Month = MID([Column1],__FirstHyphen+2,__SecondHyphen - __FirstHyphen - 1)
    VAR __Year = RIGHT(__Date,LEN(__Date) - __SecondHyphen)
    VAR __NewDate = __Month & "-" & __Day & "-" & __Year
RETURN
    __NewDate

     

     PBIX is attached below sig. Table (17a)