FAQ

Yes, it is ideal for the Date column to be standardized.

You can use Date Change to make the dates a consistent format (Ex: MM/DD/YYYY). If your statement contains multiple years, be careful. You will have to use SHIFT + Click to perform Date Change with one year’s data selected at a time.

If there are extra characters, select the rows and click Edit Data->Edit.

Choose the column name and click Selected Replace.

Type in the characters. In this example, type in “_” first and leave the “Replace to” blank. Click Apply.

“_” is now removed.

Continue to remove ‘…’ by repeating the above processes.

Date column is clean now.

It depends on two circumstances:

• If the date is in MM/DD or DD/MM format and you need to append the year using Date Change feature, you would need to do the change three times—once for each year.
• If the date column already contains a year, such as MM/DD/YY, DD/MM/YY, MM-DD-YY, DD-MM-YY, Date Change can unify the format at a click:

Select the row and click Edit Data and Date Change. Select the Date Format. Leave the Year blank.

Dates are changed into the selected format no matter how many years the statement spans.

The Date Swap feature can help to swap the date from MM/DD to DD/MM. Go to Edit Data > Date Swap. The month and date sections will be switched.