Hi every one,
How I can to calculate the Past Due Days for the Salary for example just i have the Past Due Date
Numer Provider Past Due Date Past Due Days
12345678 25/11/2015 = 25/11/2015 - today()
34567811 29/12/2015 = 29/12/2015 - today()
I mean i dont have a calendary to do this can you help
May be like this:
LOAD [Numer Provider],
[Past Due Date],
([Past Due Date] - Today()) as [Past Due Days]
If you want to know how much days left from today, uses the sintax:
Today()-[Past Due Date] as "DaysFrom"
Anyway, you can use other functions like null, date format.
Please, mark the CORRECT/HELPFULL comment to help us.
Retrieving data ...