Forum Discussion

IF's avatar
IF
Post Prodigy
2 years ago
Solved

text format date in power query - m

i tried the code: = Date.ToText(Date.From(DateTime.LocalNow()), "dd.MM.yyyy") to get the date in text format, but i got wrong result as attached. it shows "00" instead of "12".  is there any other wa...
  • AlienSx's avatar
    AlienSx
    2 years ago

  • slorin's avatar
    2 years ago

    Hi

    MM = month

    mm = minutes

     

     

  • Syndicate_Admin's avatar
    2 years ago

    Hi @Syndicate_Admin 

    Please try below code

     

    = Date.ToText(Date.From(DateTime.LocalNow()), [Format="dd MM yyyy"])

     

     


    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS 👍

     

    Thanks
    Pijush