Hi All,
I have date in timestamp format like "01/30/2018 10:56:01 AM". Now I want previous 2 months data.
I tried this,
Vmaxdate=date(peek(maxdate));
Vmonthstart=monthstart(maxdate,-2);
Vmonthend=monthend(maxdate,-1);
Issue is,
I am getting the date from Aug 1st to sep 29th but I need Aug 1st to sep 30th. Could you please let me know how to handle this kind of problem. I know that monthend falls into time 11:59.
