Date Range

[dineshkumar]

Hi all,

     How can i arrange the date in date range like jan-feb, mar-apr, may-jun and so on... for the following dates

  2014-12-31 06:23:46.480,

    2015-04-01 04:34:51.893,

    2015-04-05 08:33:49.000,

    2015-04-08 04:14:01.190,

    2015-04-08 09:16:12.570,

    2015-04-08 09:26:32.623,

    2015-04-09 07:44:57.520,

    2015-04-09 07:48:54.040,

    2015-04-09 10:41:21.247,

    2015-04-09 12:33:02.633,

    2015-04-09 12:34:06.483,

    2015-05-09 12:37:28.697,

    2015-06-09 12:39:06.563,

    2015-07-09 12:40:35.963,

    2015-07-10 03:06:26.247,

    2015-07-10 04:39:57.587,

    2015-07-10 06:11:12.137,

    2015-07-10 07:46:29.457,

    2015-08-10 07:53:05.203,

    2015-08-10 08:06:23.187,

    2015-08-10 10:39:05.533,

    2015-08-10 11:31:07.877,

    2015-08-11 03:47:55.707,

    2015-09-12 12:51:41.133,

    2015-09-15 08:29:49.723,

    2015-09-15 08:49:41.887,

    2015-09-15 16:55:54.187,

    2015-09-16 09:07:17.297

Thanks & Regards

Dinesh

[rubenmarin · Accepted solution]

Hi Dinesh, this script worked for me:

Data:

LOAD Date, If(Even(Month(Date)), Text(Month(AddMonths(Date, -1))) & '-' & Text(Month(Date)),

                            Text(Month(Date)) & '-' & Text(Month(AddMonths(Date, 1)))) as Range;

LOAD Date(Date#(Date, 'YYYY-MM-DD hh:mm:ss[.fff]')) as Date Inline [

Date

2014-12-31 06:23:46.480,

    2015-04-01 04:34:51.893

    2015-05-09 12:37:28.697

    2015-06-09 12:39:06.563

    2015-07-10 07:46:29.457

    2015-08-10 07:53:05.203

    2015-09-12 12:51:41.133

];