Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Extract date from Text and plot as date column in table

Hi

I've got some data in text format with a date range attached. I've just made a date column and want to populate it with the above date range.

Please assist me with this. Attached snap.

 

I am using custom column to create date in power query with = #date( Year, Month, Day) to poulate entire colume with unique date.

Thanks

Saibal

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Is the date not there in any of the rows below, it is there in the header?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Amit,

      Yes Date range mentioned in the header text. I want to exctract Date from header text "Booking Stay report Between: 1-Jul-22 to 30-Sep-22.to want to plot in two column start date and end date.

      Thanks

      Saibal

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Anonymous ,

    Do you want to convert [Booking ID] to date format, what is the conversion format between them.

    I converted according to the previous "7 Digit Julian Date conversion", the date is not between 2022.7.1-2022.9.30.

    Date.AddDays(#date(Number.RoundDown([Booking ID]/1000),1,1),Number.Mod([Booking ID],1000)-1)

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Liu Yang,

      I want to exctract Date from header text "Booking Stay report Between: 1-Jul-22 to 30-Sep-22.to want to plot in two column start date and end date.

       

      I am using custom column to create date in power query with = #date( Year, Month, Day) to poulate entire colume with unique date.

       

      Thanks

      Saibal