Extract date from Text and plot as date column in table

[Anonymous]

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

[v-yangliu-msft]

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]

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

[amitchandak]

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

[Anonymous]

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