Requirement on dates

[#1]

Hi

I have created a bar chart and i selected data on value points but which is giving wrong value like 12/12/1900 instead of 12/09/2014.what is the issue and what is the solution.

Thanks

siddiq

[sunny_talwar]

Can you try this as your dimension:

Date(Date#(DateField, 'DD/MM/YYYY'))

[#3]

hi

i am getting like this and i want to show start date and end date on the bar

[sunny_talwar]

Can you show your dimension expression?

[#5]

hi my expression is like this

date(Max( [Solution Proposal Finish]))-date(Min([Solution Proposal Start]))

and also i am implementing gannt chart

[sunny_talwar]

Max-Min gives the number of days. How do you expect to see a date for that?

[#7]

dimension is stag number 5225

[#8]

Hi,

Try using this,

Date(Date#([Solution Proposal Finish], 'DD/MM/YYYY'))

Regards,

Snehal Nabar

[PrashantSangle]

Hi,

check in text object.

> =max([Solution Proposal Finish])

> =min([Solution Proposal Start])

> = max([Solution Proposal Finish])-min([Solution Proposal Start])

> = date(max([Solution Proposal Finish])-min([Solution Proposal Start]))

Regards