Forum Discussion

Amazing_Random's avatar
Amazing_Random
Icon for Helper I rankHelper I
3 years ago
Solved

Formatting date text string to a custom format

For a report I have to use a link into the meter name. I have been able to crack down the id aspect of the link. but the date on such link is quite off to the date/time formats in PBI. &chartEndDa...
Need Help
  • bolfri's avatar
    bolfri
    3 years ago

    Do you need something like this? This formula uses the UTCNOW() function to get the current UTC time and the FORMAT function to format the datetime in the desired format. You can replace UTCNOW() function with the column you have.

     

    Column = CONCATENATE(
    FORMAT(UTCNOW(), "yyyy-MM-ddT"),
    SUBSTITUTE(
            FORMAT(UTCNOW(), "HH:mm:ss.fffZ"),
            ":",
            "%3A"
    )
)

     

     

     

Amazing_Random's avatar
Amazing_Random
Icon for Helper I rankHelper I
3 years ago

Hi! This one is much closer but I'm experiencing issues with some rows. It seems it doesn't work for all the dates I have

JB505's avatar
JB505
Frequent Visitor
3 years ago

Amazing_Random 
Can you include both columns with the original date and the new formatted date?