Date Problem

[smilingjohn]

Hi Expertise please find the attachment of the QVW file ..

I have added a filter which has R_Load Date field .

If i try to sort it by descending it is not considering
and also i have tried to set the max date, by using the below expression with the text object

=Date(Max({1}[R_Load Date]),'M/D/YYYY')

=Date(Max(All [R_Load Date]),'M/D/YYYY')

But nothing is working

Need help on this

Thanks in Advance

[tresesco]

Your date field has text values, you need to convert it to date values using date#(). To resolve the problems at the source reload the date field like:

Date(Date#([R_Load Date], 'MM-DD-YYYY'), 'M/D/YYYY') as [R_Load Date]

[smilingjohn]

Hi MVP

I made the suggested changes at the script and reloaded the application. 

Date(Date#([R_Load Date], 'MM-DD-YYYY'), 'M/D/YYYY') as [R_Load Date]

after reloading i dont see any value in it ? 

[tresesco]

That means, date values in your source is not in 'MM-DD-YYYY' format. What is your source? How doe date values look like there? Replace the date#() format with that one.

[smilingjohn]

Hi MVM 

Actaully the date at the DB itself is as shown in the below format .

date from source

and i have converted it to " date#(date(R_LOAD_DATE),'MM/DD/YYYY') as [R_Load Date]"

How do i deal with this ?

[tresesco]

So it's proper date values. And if you just want the date part (without time portion), you could load it like:
Load

Date(Floor(LOAD_DATE), 'M/D/YYYY')) as [R_Load Date]

[smilingjohn]

Hi MVP , 

Thanks the date format conversion worked , but now i am not able to set the max date  , 

i have added a text object and it is not considering the max date , 

Please find the attachment of the QVW file . 

Thanks 

[vipin_mishra479]

Try =Date(Max(Reload))in text box

[smilingjohn]

I want to set this in actions . 

when i land from another  sheet then the date should set to  max of reload date . 

[vipin_mishra479]

I have attached the file please check