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.   ...
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