add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 8432  Duplicates: 0  Warnings: 0
TheDate TheYear TheMonth TheDay WeekdayOfFirst IsLastOfMonth NeedsClosingYear
2023-02-28 2023 2 28 null 1 0
2023-02-01 2023 2 1 4 0 0
2023-01-31 2023 1 31 null 1 1
2023-01-01 2023 1 1 1 0 0
2022-12-31 2022 12 31 null 1 0
2022-12-01 2022 12 1 5 0 0
2022-11-30 2022 11 30 null 1 0
2022-11-01 2022 11 1 3 0 0
2022-10-31 2022 10 31 null 1 0
2022-10-01 2022 10 1 7 0 0
2022-09-30 2022 9 30 null 1 0
2022-09-01 2022 9 1 5 0 0
2022-08-31 2022 8 31 null 1 0
2022-08-01 2022 8 1 2 0 0
2022-07-31 2022 7 31 null 1 0
2022-07-01 2022 7 1 6 0 0
2022-06-30 2022 6 30 null 1 0
2022-06-01 2022 6 1 4 0 0
2022-05-31 2022 5 31 null 1 0
2022-05-01 2022 5 1 1 0 0
2022-04-30 2022 4 30 null 1 0
2022-04-01 2022 4 1 6 0 0
2022-03-31 2022 3 31 null 1 0
2022-03-01 2022 3 1 3 0 0
2022-02-28 2022 2 28 null 1 0
2022-02-01 2022 2 1 3 0 0
2022-01-31 2022 1 31 null 1 1
2022-01-01 2022 1 1 7 0 0
2021-12-31 2021 12 31 null 1 0
2021-12-01 2021 12 1 4 0 0
2021-11-30 2021 11 30 null 1 0
2021-11-01 2021 11 1 2 0 0
2021-10-31 2021 10 31 null 1 0
2021-10-01 2021 10 1 6 0 0
2021-09-30 2021 9 30 null 1 0
2021-09-01 2021 9 1 4 0 0
2021-08-31 2021 8 31 null 1 0
2021-08-01 2021 8 1 1 0 0
2021-07-31 2021 7 31 null 1 0
2021-07-01 2021 7 1 5 0 0
2021-06-30 2021 6 30 null 1 0
2021-06-01 2021 6 1 3 0 0
2021-05-31 2021 5 31 null 1 0
2021-05-01 2021 5 1 7 0 0
2021-04-30 2021 4 30 null 1 0
2021-04-01 2021 4 1 5 0 0
2021-03-31 2021 3 31 null 1 0
2021-03-01 2021 3 1 2 0 0
2021-02-28 2021 2 28 null 1 0
2021-02-01 2021 2 1 2 0 0
2021-01-31 2021 1 31 null 1 1
2021-01-01 2021 1 1 6 0 0
2020-12-31 2020 12 31 null 1 0
2020-12-01 2020 12 1 3 0 0
2020-11-30 2020 11 30 null 1 0
2020-11-01 2020 11 1 1 0 0
2020-10-31 2020 10 31 null 1 0
2020-10-01 2020 10 1 5 0 0
2020-09-30 2020 9 30 null 1 0
2020-09-01 2020 9 1 3 0 0
2020-08-31 2020 8 31 null 1 0
2020-08-01 2020 8 1 7 0 0
2020-07-31 2020 7 31 null 1 0
2020-07-01 2020 7 1 4 0 0
2020-06-30 2020 6 30 null 1 0
2020-06-01 2020 6 1 2 0 0
2020-05-31 2020 5 31 null 1 0
2020-05-01 2020 5 1 6 0 0
2020-04-30 2020 4 30 null 1 0
2020-04-01 2020 4 1 4 0 0
2020-03-31 2020 3 31 null 1 0
2020-03-01 2020 3 1 1 0 0
2020-02-29 2020 2 29 null 1 0
2020-02-01 2020 2 1 7 0 0
2020-01-31 2020 1 31 null 1 1
2020-01-01 2020 1 1 4 0 0
2019-12-31 2019 12 31 null 1 0
2019-12-01 2019 12 1 1 0 0
2019-11-30 2019 11 30 null 1 0
2019-11-01 2019 11 1 6 0 0
2019-10-31 2019 10 31 null 1 0
2019-10-01 2019 10 1 3 0 0
2019-09-30 2019 9 30 null 1 0
2019-09-01 2019 9 1 1 0 0
2019-08-31 2019 8 31 null 1 0
2019-08-01 2019 8 1 5 0 0
2019-07-31 2019 7 31 null 1 0
2019-07-01 2019 7 1 2 0 0
2019-06-30 2019 6 30 null 1 0
2019-06-01 2019 6 1 7 0 0
2019-05-31 2019 5 31 null 1 0
2019-05-01 2019 5 1 4 0 0
2019-04-30 2019 4 30 null 1 0
2019-04-01 2019 4 1 2 0 0
2019-03-31 2019 3 31 null 1 0
2019-03-01 2019 3 1 6 0 0
2019-02-28 2019 2 28 null 1 0
2019-02-01 2019 2 1 6 0 0
2019-01-31 2019 1 31 null 1 1
2019-01-01 2019 1 1 3 0 0
2018-12-31 2018 12 31 null 1 0
2018-12-01 2018 12 1 7 0 0
2018-11-30 2018 11 30 null 1 0
2018-11-01 2018 11 1 5 0 0
2018-10-31 2018 10 31 null 1 0
2018-10-01 2018 10 1 2 0 0
2018-09-30 2018 9 30 null 1 0
2018-09-01 2018 9 1 7 0 0
2018-08-31 2018 8 31 null 1 0
2018-08-01 2018 8 1 4 0 0
2018-07-31 2018 7 31 null 1 0
2018-07-01 2018 7 1 1 0 0
2018-06-30 2018 6 30 null 1 0
2018-06-01 2018 6 1 6 0 0
2018-05-31 2018 5 31 null 1 0
2018-05-01 2018 5 1 3 0 0
2018-04-30 2018 4 30 null 1 0
2018-04-01 2018 4 1 1 0 0
2018-03-31 2018 3 31 null 1 0
2018-03-01 2018 3 1 5 0 0
2018-02-28 2018 2 28 null 1 0
2018-02-01 2018 2 1 5 0 0
2018-01-31 2018 1 31 null 1 1
2018-01-01 2018 1 1 2 0 0
2017-12-31 2017 12 31 null 1 0
2017-12-01 2017 12 1 6 0 0
2017-11-30 2017 11 30 null 1 0
2017-11-01 2017 11 1 4 0 0
2017-10-31 2017 10 31 null 1 0
2017-10-01 2017 10 1 1 0 0
2017-09-30 2017 9 30 null 1 0
2017-09-01 2017 9 1 6 0 0
2017-08-31 2017 8 31 null 1 0
2017-08-01 2017 8 1 3 0 0
2017-07-31 2017 7 31 null 1 0
2017-07-01 2017 7 1 7 0 0
2017-06-30 2017 6 30 null 1 0
2017-06-01 2017 6 1 5 0 0
2017-05-31 2017 5 31 null 1 0
2017-05-01 2017 5 1 2 0 0
2017-04-30 2017 4 30 null 1 0
2017-04-01 2017 4 1 7 0 0
2017-03-31 2017 3 31 null 1 0
2017-03-01 2017 3 1 4 0 0
2017-02-28 2017 2 28 null 1 0
2017-02-01 2017 2 1 4 0 0
2017-01-31 2017 1 31 null 1 1
2017-01-01 2017 1 1 1 0 0
2016-12-31 2016 12 31 null 1 0
2016-12-01 2016 12 1 5 0 0
2016-11-30 2016 11 30 null 1 0
2016-11-01 2016 11 1 3 0 0
2016-10-31 2016 10 31 null 1 0
2016-10-01 2016 10 1 7 0 0
2016-09-30 2016 9 30 null 1 0
2016-09-01 2016 9 1 5 0 0
2016-08-31 2016 8 31 null 1 0
2016-08-01 2016 8 1 2 0 0
2016-07-31 2016 7 31 null 1 0
2016-07-01 2016 7 1 6 0 0
2016-06-30 2016 6 30 null 1 0
2016-06-01 2016 6 1 4 0 0
2016-05-31 2016 5 31 null 1 0
2016-05-01 2016 5 1 1 0 0
2016-04-30 2016 4 30 null 1 0
2016-04-01 2016 4 1 6 0 0
2016-03-31 2016 3 31 null 1 0
2016-03-01 2016 3 1 3 0 0
2016-02-29 2016 2 29 null 1 0
2016-02-01 2016 2 1 2 0 0
2016-01-31 2016 1 31 null 1 1
2016-01-01 2016 1 1 6 0 0
2015-12-31 2015 12 31 null 1 0
2015-12-01 2015 12 1 3 0 0
2015-11-30 2015 11 30 null 1 0
2015-11-01 2015 11 1 1 0 0
2015-10-31 2015 10 31 null 1 0
2015-10-01 2015 10 1 5 0 0
2015-09-30 2015 9 30 null 1 0
2015-09-01 2015 9 1 3 0 0
2015-08-31 2015 8 31 null 1 0
2015-08-01 2015 8 1 7 0 0
2015-07-31 2015 7 31 null 1 0
2015-07-01 2015 7 1 4 0 0
2015-06-30 2015 6 30 null 1 0
2015-06-01 2015 6 1 2 0 0
2015-05-31 2015 5 31 null 1 0
2015-05-01 2015 5 1 6 0 0
2015-04-30 2015 4 30 null 1 0
2015-04-01 2015 4 1 4 0 0
2015-03-31 2015 3 31 null 1 0
2015-03-01 2015 3 1 1 0 0
2015-02-28 2015 2 28 null 1 0
2015-02-01 2015 2 1 1 0 0
2015-01-31 2015 1 31 null 1 1
2015-01-01 2015 1 1 5 0 0
2014-12-31 2014 12 31 null 1 0
2014-12-01 2014 12 1 2 0 0
2014-11-30 2014 11 30 null 1 0
2014-11-01 2014 11 1 7 0 0
2014-10-31 2014 10 31 null 1 0
2014-10-01 2014 10 1 4 0 0
2014-09-30 2014 9 30 null 1 0
2014-09-01 2014 9 1 2 0 0
2014-08-31 2014 8 31 null 1 0
2014-08-01 2014 8 1 6 0 0
2014-07-31 2014 7 31 null 1 0
2014-07-01 2014 7 1 3 0 0
2014-06-30 2014 6 30 null 1 0
2014-06-01 2014 6 1 1 0 0
2014-05-31 2014 5 31 null 1 0
2014-05-01 2014 5 1 5 0 0
2014-04-30 2014 4 30 null 1 0
2014-04-01 2014 4 1 3 0 0
2014-03-31 2014 3 31 null 1 0
2014-03-01 2014 3 1 7 0 0
2014-02-28 2014 2 28 null 1 0
2014-02-01 2014 2 1 7 0 0
2014-01-31 2014 1 31 null 1 1
2014-01-01 2014 1 1 4 0 0
2013-12-31 2013 12 31 null 1 0
2013-12-01 2013 12 1 1 0 0
2013-11-30 2013 11 30 null 1 0
2013-11-01 2013 11 1 6 0 0
2013-10-31 2013 10 31 null 1 0
2013-10-01 2013 10 1 3 0 0
2013-09-30 2013 9 30 null 1 0
2013-09-01 2013 9 1 1 0 0
2013-08-31 2013 8 31 null 1 0
2013-08-01 2013 8 1 5 0 0
2013-07-31 2013 7 31 null 1 0
2013-07-01 2013 7 1 2 0 0
2013-06-30 2013 6 30 null 1 0
2013-06-01 2013 6 1 7 0 0
2013-05-31 2013 5 31 null 1 0
2013-05-01 2013 5 1 4 0 0
2013-04-30 2013 4 30 null 1 0
2013-04-01 2013 4 1 2 0 0
2013-03-31 2013 3 31 null 1 0
2013-03-01 2013 3 1 6 0 0
2013-02-28 2013 2 28 null 1 0
2013-02-01 2013 2 1 6 0 0
2013-01-31 2013 1 31 null 1 1
2013-01-01 2013 1 1 3 0 0
2012-12-31 2012 12 31 null 1 0
2012-12-01 2012 12 1 7 0 0
2012-11-30 2012 11 30 null 1 0
2012-11-01 2012 11 1 5 0 0
2012-10-31 2012 10 31 null 1 0
2012-10-01 2012 10 1 2 0 0
2012-09-30 2012 9 30 null 1 0
2012-09-01 2012 9 1 7 0 0
2012-08-31 2012 8 31 null 1 0
2012-08-01 2012 8 1 4 0 0
2012-07-31 2012 7 31 null 1 0
2012-07-01 2012 7 1 1 0 0
2012-06-30 2012 6 30 null 1 0
2012-06-01 2012 6 1 6 0 0
2012-05-31 2012 5 31 null 1 0
2012-05-01 2012 5 1 3 0 0
2012-04-30 2012 4 30 null 1 0
2012-04-01 2012 4 1 1 0 0
2012-03-31 2012 3 31 null 1 0
2012-03-01 2012 3 1 5 0 0
2012-02-29 2012 2 29 null 1 0
2012-02-01 2012 2 1 4 0 0
2012-01-31 2012 1 31 null 1 1
2012-01-01 2012 1 1 1 0 0
2011-12-31 2011 12 31 null 1 0
2011-12-01 2011 12 1 5 0 0
2011-11-30 2011 11 30 null 1 0
2011-11-01 2011 11 1 3 0 0
2011-10-31 2011 10 31 null 1 0
2011-10-01 2011 10 1 7 0 0
2011-09-30 2011 9 30 null 1 0
2011-09-01 2011 9 1 5 0 0
2011-08-31 2011 8 31 null 1 0
2011-08-01 2011 8 1 2 0 0
2011-07-31 2011 7 31 null 1 0
2011-07-01 2011 7 1 6 0 0
2011-06-30 2011 6 30 null 1 0
2011-06-01 2011 6 1 4 0 0
2011-05-31 2011 5 31 null 1 0
2011-05-01 2011 5 1 1 0 0
2011-04-30 2011 4 30 null 1 0
2011-04-01 2011 4 1 6 0 0
2011-03-31 2011 3 31 null 1 0
2011-03-01 2011 3 1 3 0 0
2011-02-28 2011 2 28 null 1 0
2011-02-01 2011 2 1 3 0 0
2011-01-31 2011 1 31 null 1 1
2011-01-01 2011 1 1 7 0 0
2010-12-31 2010 12 31 null 1 0
2010-12-01 2010 12 1 4 0 0
2010-11-30 2010 11 30 null 1 0
2010-11-01 2010 11 1 2 0 0
2010-10-31 2010 10 31 null 1 0
2010-10-01 2010 10 1 6 0 0
2010-09-30 2010 9 30 null 1 0
2010-09-01 2010 9 1 4 0 0
2010-08-31 2010 8 31 null 1 0
2010-08-01 2010 8 1 1 0 0
2010-07-31 2010 7 31 null 1 0
2010-07-01 2010 7 1 5 0 0
2010-06-30 2010 6 30 null 1 0
2010-06-01 2010 6 1 3 0 0
2010-05-31 2010 5 31 null 1 0
2010-05-01 2010 5 1 7 0 0
2010-04-30 2010 4 30 null 1 0
2010-04-01 2010 4 1 5 0 0
2010-03-31 2010 3 31 null 1 0
2010-03-01 2010 3 1 2 0 0
2010-02-28 2010 2 28 null 1 0
2010-02-01 2010 2 1 2 0 0
2010-01-31 2010 1 31 null 1 1
2010-01-01 2010 1 1 6 0 0
2009-12-31 2009 12 31 null 1 0
2009-12-01 2009 12 1 3 0 0
2009-11-30 2009 11 30 null 1 0
2009-11-01 2009 11 1 1 0 0
2009-10-31 2009 10 31 null 1 0
2009-10-01 2009 10 1 5 0 0
2009-09-30 2009 9 30 null 1 0
2009-09-01 2009 9 1 3 0 0
2009-08-31 2009 8 31 null 1 0
2009-08-01 2009 8 1 7 0 0
2009-07-31 2009 7 31 null 1 0
2009-07-01 2009 7 1 4 0 0
2009-06-30 2009 6 30 null 1 0
2009-06-01 2009 6 1 2 0 0
2009-05-31 2009 5 31 null 1 0
2009-05-01 2009 5 1 6 0 0
2009-04-30 2009 4 30 null 1 0
2009-04-01 2009 4 1 4 0 0
2009-03-31 2009 3 31 null 1 0
2009-03-01 2009 3 1 1 0 0
2009-02-28 2009 2 28 null 1 0
2009-02-01 2009 2 1 1 0 0
2009-01-31 2009 1 31 null 1 1
2009-01-01 2009 1 1 5 0 0
2008-12-31 2008 12 31 null 1 0
2008-12-01 2008 12 1 2 0 0
2008-11-30 2008 11 30 null 1 0
2008-11-01 2008 11 1 7 0 0
2008-10-31 2008 10 31 null 1 0
2008-10-01 2008 10 1 4 0 0
2008-09-30 2008 9 30 null 1 0
2008-09-01 2008 9 1 2 0 0
2008-08-31 2008 8 31 null 1 0
2008-08-01 2008 8 1 6 0 0
2008-07-31 2008 7 31 null 1 0
2008-07-01 2008 7 1 3 0 0
2008-06-30 2008 6 30 null 1 0
2008-06-01 2008 6 1 1 0 0
2008-05-31 2008 5 31 null 1 0
2008-05-01 2008 5 1 5 0 0
2008-04-30 2008 4 30 null 1 0
2008-04-01 2008 4 1 3 0 0
2008-03-31 2008 3 31 null 1 0
2008-03-01 2008 3 1 7 0 0
2008-02-29 2008 2 29 null 1 0
2008-02-01 2008 2 1 6 0 0
2008-01-31 2008 1 31 null 1 1
2008-01-01 2008 1 1 3 0 0
2007-12-31 2007 12 31 null 1 0
2007-12-01 2007 12 1 7 0 0
2007-11-30 2007 11 30 null 1 0
2007-11-01 2007 11 1 5 0 0
2007-10-31 2007 10 31 null 1 0
2007-10-01 2007 10 1 2 0 0
2007-09-30 2007 9 30 null 1 0
2007-09-01 2007 9 1 7 0 0
2007-08-31 2007 8 31 null 1 0
2007-08-01 2007 8 1 4 0 0
2007-07-31 2007 7 31 null 1 0
2007-07-01 2007 7 1 1 0 0
2007-06-30 2007 6 30 null 1 0
2007-06-01 2007 6 1 6 0 0
2007-05-31 2007 5 31 null 1 0
2007-05-01 2007 5 1 3 0 0
2007-04-30 2007 4 30 null 1 0
2007-04-01 2007 4 1 1 0 0
2007-03-31 2007 3 31 null 1 0
2007-03-01 2007 3 1 5 0 0
2007-02-28 2007 2 28 null 1 0
2007-02-01 2007 2 1 5 0 0
2007-01-31 2007 1 31 null 1 1
2007-01-01 2007 1 1 2 0 0
2006-12-31 2006 12 31 null 1 1
2006-12-01 2006 12 1 6 0 0