Re: Convert quarterly date (Q3 2022) to numeric date

SeanFL — Fri, 22 Jul 2022 18:34:20 GMT

Thank you so much. That worked perfectly.

Convert quarterly date (Q3 2022) to numeric date

SeanFL — Wed, 20 Jul 2022 19:55:42 GMT

Hey,

I'm have a column of dates, some of which are formatted numerically 3/2/2022, some of which are entered as "Q1 2023", and a few "null" entries. The column itself is of Any (ABC-123). I'm trying to create a new column that copies dates entered in the numeric format and those that are null and changes anything written as a quarterly date into a generic placeholder date.

Q1 - 1/1/2023

Q2 - 4/1/2023

Q3 - 7/1/2023

Q4 - 10/1/2023

I know my code doesn't work and I appreciate any direction or assistance.

if Type.Is([Target Dev Start], Date.Type) = true or null then [Target Dev Start] else Date.StartOfQuarter(#date(Number.From(Text.End([String],4)), Number.From(Text.Start([String], 2)), 1))

SeanFL Tracker

Re: Convert quarterly date (Q3 2022) to numeric date

Convert quarterly date (Q3 2022) to numeric date