Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
we are displaying when the data was last updated in DWH.on right upper corner of the application..
we are writing the below code for it,
='LAST LOAD DATE : '& max(date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))
The last load date is changing as per the selection... For example If i select year prompt..its showing one date and if i select any region,,its showing another date..
can you please let me know how to achive this to do not change the date.. thanks in advance
='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))
Hi,
Write SET expression to avoid selections
='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))
Regards,
Anand
But why you not use the ReloadTime() or Now() function for the same you can use it like
='LAST LOAD DATE : '& date( ReloadTime(),'DD-MMM-YYYY' )
Or
='LAST LOAD DATE : '& date( Now(),'DD-MMM-YYYY' )
Regards
Anand
Hi,
why not display the result of the internal variable reloadtime()?
HTH Peter