Forum Discussion

Roost1969's avatar
Roost1969
Frequent Visitor
2 years ago
Solved

Timestamp format

Goodday,

 

I have a CSV file withe a data-time field witch has the format (Jan 12, 2024 @ 19:39:03.793).

Is there a way to convert this format to a DD-MM-YYYY, HH:MM:SS ?

 

Tips and Tricks
  • AlienSx's avatar
    AlienSx
    2 years ago

    Roost1969 

        DateTime.ToText(
        DateTime.FromText("Jan 12, 2024 @ 19:39:03.793", [Format = "MMM dd, yyyy '@' HH:mm:ss.fff"]),
        [Format = "dd-MM-yyyy, HH:mm:ss"]
    )

3 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    Roost1969 

        DateTime.ToText(
        DateTime.FromText("Jan 12, 2024 @ 19:39:03.793", [Format = "MMM dd, yyyy '@' HH:mm:ss.fff"]),
        [Format = "dd-MM-yyyy, HH:mm:ss"]
    )
    • Roost1969's avatar
      Roost1969
      Frequent Visitor
      2 years ago

      I can't find the DateTime.ToText function in dax

       

      • AlienSx's avatar
        AlienSx
        Super User
        2 years ago

        Roost1969 it's Power Query forum. By default you are requesting a help with M, not DAX.