How to calculate no. of days for an employee if i have names dates in a table

[shamsul]

Hi @Idrissshatila I have two tables, one with Employee Name and Employee code and other with Employee code,dates, amount and other detaitails. I want to create a new column which can show which employee worked for how many days so i can calculate earing per day of an employee.

[Idrissshatila]

@shamsul,

Okay so you go in the second table and you create a new column as the following

Number of days =
DATEDIFF ( startingDate, TODAY (), DAY )

this new column will give you number of days for each row between the date that in in the table and today. Then you can visualise it with employee name.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[shamsul]

@Idrissshatila Expression.Error: The name 'DATEDIFF' wasn't recognized. Make sure it's spelled correctly.

[Idrissshatila]

@shamsul, can you show me the formula you wrote without showing any sensitive data please?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[shamsul]

@Idrissshatila table 1

employee id	name	payroll_enrollment_id
4	Karan	14
325	RANI.S	2612
326	SWETHA.T	2545
327	MEENAKSHI.S	2453
329	MANGALESWARI.S	2517
332	A.R	2118
334	VASANTHI.R	2089
337	MUTHURAKKU.M	2198
339	MUTHULAKSHMI.S	2481
340	GIRIJA	2649
345	MAHALAKSHMI.S	2711
346	MUTHULAKSHMI.P	2419
347	RAJESWARI.K	524
348	VANITHA.C	2366
349	R.SUSILA	518

[Idrissshatila]

Hello @shamsul ,

Can you provide more details so we could help you ?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin