Hi all,
I have one column and that column contain 2 years dates . this column contain like every day data.
column example data: 2018-07-23 05:00:00.000
2018-07-24 05:00:00.000
2018-07-26 05:00:00.000
2018-07-28 05:00:00.000
2017-07-23 05:00:00.000
2017-07-24 05:00:00.000
2017-07-26 05:00:00.000
2017-07-28 05:00:00.000
etc for 3rd year alsolike wise 3 years data. now i wanted to get missing dates from above data.
example:in 2018 i have 23 ,24 26,28 days data but
my query should return these 25 and 28 two dates like wise missing all 3 years months dates
could any one help on this?
Jignesh KumarPosted Aug 20, 2018, 10:33 AM