Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data transformation challenge - Jira data source

Hi all , my data source is Jira and one of the columns I require is the "Last Comment Date" which is a text column which I would like to be in date format.   The challenge being that this text colu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    In the end I added a custom column using the following 

    = Table.AddColumn(#"Renamed Columns35", "LastCommentDateModified", each let

    a = Text.BeforeDelimiter([LastCommentDate], " "),

    b = Date.FromText(a, [Format="yyyy-MM-dd"]),

    c = Text.BetweenDelimiters([LastCommentDate], " ", " ", 0 ,1),

    d = Text.End([LastCommentDate], 4),

    e = try b otherwise Date.FromText(c&d, [Format="MMM ddyyyy"])

    in e)

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

In the end I added a custom column using the following 

= Table.AddColumn(#"Renamed Columns35", "LastCommentDateModified", each let

a = Text.BeforeDelimiter([LastCommentDate], " "),

b = Date.FromText(a, [Format="yyyy-MM-dd"]),

c = Text.BetweenDelimiters([LastCommentDate], " ", " ", 0 ,1),

d = Text.End([LastCommentDate], 4),

e = try b otherwise Date.FromText(c&d, [Format="MMM ddyyyy"])

in e)