DATE TO NUMBER OF DAYS

[sagaraperera]

Dear All

I want to get a number of days using given data

MARKETING_DATE - 31-05-2019 

sagara

[lazurens · Accepted solution]

It's not clear number of days since when exactly ? 

If you mean number of days from the start of the year you can use the function DayNumberOf Year('05/31/2019')

If you mean the number of days between a date in the past and today

use this expression : 

Regards,

Mohamed

[sagaraperera]

thanks boss it is work

can you help 

get a last month max date using following

MARKETING_DATE

sagara

[lazurens]

MonthEnd(Max(Date(MARKETING_DATE)))

Mohamed