Date

[#1]

Hi Friends,

I have two different excels  IR dump and stratification Audit, with no relation

in IR dump there is date field, stratification Audit don't have.

I would like to create a relation b/w the dumps using date ..

so what i have done is  renamed the excel with prefix 12092015  and it became as 12092015 stratification Audit and extracted that.

I used both Filename() and filetime() to get the date field,

left(filename(),+9),

i got the output as 12092015.

now what happening is i am not able to format the date as 12/09/2015 and i want to add two days for that

Eg: date(12/09/2015)+2 =12/11/2015, so that i can make relation between two tables.

I used the below one, but it is not working..

Date(Date#(left(filename(),+9),'MM/DD/YYYY'),'DD/MM/YYYY'),

Date(Date#(left(filetime(),+9),'MM/DD/YYYY'),'DD/MM/YYYY')

please help me to do this.

[#2]

Sunny,

Thank you for your reply,

when i will take max date as dimension in my chart max date is coming,

sum of both dates data is coming .. please suggest me where i have done wrong?

[sunny_talwar]

I think what you are looking for can be achieved without creating MaxDate in Script. Try using FirstSortedValue() function

FirstSortedValue(Field, -DateField)

I feel that generally the above function can be used, but your data may require to change some things around. Would you be able to share a sample?