Last load date of Data..

[#1]

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

[MK_QSL]

='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))

[its_anandrjs]

Hi,

Write SET expression to avoid selections

='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))

Regards,

Anand

[its_anandrjs]

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

[prieper]

Hi,

why not display the result of the internal variable reloadtime()?

HTH Peter