Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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 ?
Hi MVM
Actaully the date at the DB itself is as shown in the below format .
and i have converted it to " date#(date(R_LOAD_DATE),'MM/DD/YYYY') as [R_Load Date]"
How do i deal with this ?
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]
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
I want to set this in actions .
when i land from another sheet then the date should set to max of reload date .
I have attached the file please check