Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
When i do resident load and drop the main table, I notice that the charts are broken. When i dig into it, I see that the Date field format is gone, so the expressions doesnt work.
eg- sum({<Date = {<'$(=max(Date))'>}>}sales)
sum({<Date = {<'$(=max(41913))'>}>}sales).
The Date field in the modifier expects date in DD/MM/YYYY format, but the max function is returning date as number(when i do resident load). so expression is not working. However the date in listbox is visible as DD/MM/YYYY.
Please let me know the reason.
Try this -
sum({<Date = {<'$(=max(Date(Date,'DD/MM/YYYY')))'>}>}sales)
I think you mean this:
Sum({<Date = {"$(='<' & Date(Max(Date),'DD/MM/YYYY'))"}>}sales)
Sorry for not being clear.
My question is, does resident load, remove the date format and covert to num.
That should not happen. Can you share an instance where it is happening?
That behavior is very odd, mate. Can you please share with us your script where you call the Resident Load?
Best regards,
D.A. MB
Hi Suraj,
I think this is correct behaviour.
Date is Dual field (num,text)
Date(41913) -> 01/10/2014
Max(Date) -> 41913
MaxString(Date) -> 01/10/2014
Regards,
Antonio
Thanks for all the inputs. I will properly test and get back. Thanks
I also am having a similar issue. When I try to use the Date function (i.e. Date(DATE_FIELD) as DATE_FIELD) in a resident load the function does not work; however, the function works when I use the exact same syntax with a load from a QVD.
I've also tried Date(Floor(DATE_FIELD)) as DATE_FIELD and I have the same issues with a Resident Load. Any insight would be greatly appreciated!
Thanks,
Chas