What is the set analysis(range) for the dates like 2012-09-19 10:16:04.000

[jagannalla]

Hello,

I've date column like below

Date

2012-09-19 10:16:04.000

2012-09-19 11:16:04.000

2012-09-19 12:16:04.000

2012-09-19 01:16:04.000

-In table i've Customer,Value.

Now i'll take customer as dimension and Only(Value) as expression in Line Chart. Now I need set analysis for this sum( {<Date= {“>2012-09-19 10:16:04.000<2012-09-19 11:19:04.0000000”}>} Sales )

If i write the above set analysis it is not working. If I got the result we can integrate below, If possible plz integrate with below syntax in set analysis.

Concat(DateColumn1,',') from another table ->contain only single value i.e 2012-09-19 10:16:04.000

Concat(DateColumn2,'2') from another table-> contain only single value i.e 2012-09-19 11:19:04.0000000

How to write this set anlysis?

[jagan · Accepted solution]

Hi,

I think there is an issue in the date format.  Check Now() in text object and check whether both the date formats are same.

It is better to arrive additional column which has date in the form of number using Num(Date) and use this values in the set analysis.

Hope this helps you.

Regards,

Jagan.

[jagannalla]

Your idea is good. But I got the solution with date format. After converting the date to number format it is easy to develop the set analysis code.

Thanks for your idea.

Cheers!!

Jagan