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"]
    )
AlienSx's avatar
AlienSx
Icon for Super User rankSuper 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
      Icon for Super User rankSuper User
      2 years ago

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