datediff

[kishoresakamuri]

Hi

Can i use the expression like this

datediff(datecolumn,today'sdate,day)

[Greg_Deckler · Accepted solution]

Yes, as long as datecolumn is always less than today (in the past). The format is:

Days = DATEDIFF([datecolumn],TODAY(),DAY)

This would be for a custom column.

If it is not always in the past, you could do it this way:

Days = datecolumn = TODAY() * 1.

[Baskar]

DATEDIFF(<start_date>, <end_date>, <interval>) 

Note :

Start date should be less then end date

[v-qiuyu-msft · Accepted solution]

Hi @kishoresakamuri,

Of course, you can. The syntax of DATEDIFF() is below:

DATEDIFF(<start_date>, <end_date>, <interval>) 

Best Regards,
Qiuyun Yu

[jrzytorr]

I have tried multiple times to get the diference between today and start date but always getting error. All i need is just the AGING of the line item.

Also, it should be WORKING DAYS. but I could not get beyond this...

[Greg_Deckler · Accepted solution]

Yes, as long as datecolumn is always less than today (in the past). The format is:

Days = DATEDIFF([datecolumn],TODAY(),DAY)

This would be for a custom column.

If it is not always in the past, you could do it this way:

Days = datecolumn = TODAY() * 1.