Text to columns and Delimiters

Hi all:

Wondering if I am using the correct delimiters to split the GL date into years, month and date (into 3 different columns). See below for your reference.

Currently, by using the (-) delimiters, its given me empty column split.

Appreciate any inputs in advance.

Preparation

Accepted answers

Qiu

@Hussein982
I think we need to convert the Data format from Date To String before split

New Workflow2A.yxmd

All comments

Qiu

@Hussein982
I think we need to convert the Data format from Date To String before split

New Workflow2A.yxmd

Hussein982

Thanks @Qiu

Appreciate your prompt response. Issue solved.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703