Date Type with Day

[Anonymous]

Hello

Does anyone know if it is possible to use M code in PQE to create a date type column in the following format:

Thu Apr 14 2022

Please?

[jennratten · Accepted solution]

Hello - this should do it...

Table.AddColumn(entity, "Custom", each Date.ToText(Date.From(DateTime.FixedLocalNow()), "ddd MMM d yyyy"), type date)

[jennratten · Accepted solution]

Hello - this should do it...

Table.AddColumn(entity, "Custom", each Date.ToText(Date.From(DateTime.FixedLocalNow()), "ddd MMM d yyyy"), type date)

[Anonymous]

Hi Jen

It does work, But.

I should have said that need to change the format for an existing column.

I have tried duplicating the column then incorporate the M code that you said, but, I must be doing something wrong.

= Table.TransformColumns(#"Duplicated Column1","Current Due Date DAY", each Date.ToText(Date.From(DateTime.FixedLocalNow()), "ddd d MMM yyyy"), type date)

I receive the following error:

[Anonymous · Accepted solution]

This works for transforming an existing column:

Select: Add Column, Column From Examples, From Selection > with the current date column selected, then: 

= Table.AddColumn(#"Duplicated Column1", "Custom", each Text.Combine({Date.ToText([Date Raised], "ddd"), " ", Date.ToText([Date Raised], "%d"), " ", Date.ToText([Date Raised], "MMM"), " ", Date.ToText([Date Raised], "yyyy")}), type text)

[Anonymous]

Perfect.  Thank you so much 😊

[jennratten]

Great!  You're welcome!  Please accept the solution when you have a moment.