Customer Banners (Ads) - SpiceUp. AX and SpotfireX Disclaimer



If you find this site useful and you want to support, buy me a coffee   to keep this site alive and without ads.

Setting a Property and set it to the max date value

#get the max date
maxDate = Document.Data.Tables["My DataTable"].Columns["My  Date"].RowValues.GetMaxValue().Value

Document.Properties["myMaxDate"] = maxDate

#get the latest date
dt = Document.Data.Tables["EV_EVENT_DV"]
rows = Document.ActiveFilteringSelectionReference.GetSelection(dt).AsIndexSet()

latestDate = dt.Columns["TR_Date"].RowValues.GetFormattedValue(rows.Last)


No comments: