How to find the missing period

Help
1

Hi all,

I have the xlsx table. One of the columns is date (generally it is the number) in format:

201801
201802
201803
201804
201805
201806
201808
201809
201810
201812

etc.
I would like to find out the missing periods (201807 and 201811). How can I do it?

In another table I have date format:
2018-01-31
2018-02-28
2018-03-31
etc
How to deal with such a case?

2

Read the date and then calculate what the next item should be. If you read 201801 your expected next value should be 201802. If you read 201812 your next value should be 201901. Then check and see if the next value is equal to your expected next value. If they are not equal then the next value is missing.

You can do the same thing when the format is like 2018-01-31.

3

Hi,

Refer the below workflow when the column has the format of “2018-01-31” and the format in excel is also Date format

New folder.zip (8.6 KB)

4

Thank you.

5

Hi,

Refer the below workflow when the format of the column is “201801” and the format of column in excel is String.

New folder.zip (8.8 KB)