I want to do the following, when a line (an order for example), appears for the 1st time in the dashboard, I want to give it the mark "New". When it is 1 day later, I want to see it is in 1 day, so give it the mark 1, day after this day becomes 2, and so on.
Any ideas someone?
Do you have Date field?
If(Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD') = 0,
Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD')
) as Status,
Date(DATE) as DATE,
Upper(DESCRIPTION) as DESCRIPTION,
Num(VALUE) as VALUE;
LOAD * INLINE [
May be this?
Date(Today(), 'DD MMM YYYY') - Date([Date insert in list],'DD MMM YYYY')