Extract the Month formatted as "MMM" from a date field (column)

ekaplan323 · May 25, 2016

Using Excel Power Query, I want to extract the Month formatted as "MMM" Text like Jan from a date field contained in the data as a column. Attached is the file and the Query. I created a Month column and entered Jan but I want to be able to extract and display that from the date in the Coumn 4 of the data. (See attached file).

Thanks, Eric

Bill Szysz · May 25, 2016

Hi Eric,
Change your #"Added Month" step to this below.

Code:

#"Added Month" = Table.AddColumn(#"Removed Columns", "Month", each DateTime.ToText([Column4],"MMM", "en-US"))

Regards

ekaplan323 · May 28, 2016

Worked Great

Bill Szysz said:
Hi Eric,
Change your #"Added Month" step to this below.

Code:

#"Added Month" = Table.AddColumn(#"Removed Columns", "Month", each DateTime.ToText([Column4],"MMM", "en-US"))

Regards

Eric Kaplan said:
Hi Bill,
thanks, I was close but I have to learn this syntax. I have a mental block on this programming.

Extract the Month formatted as "MMM" from a date field (column)

ekaplan323

New member

Attachments

Bill Szysz

Member

ekaplan323

New member