Based on the joining date, who is joining current year and Last 6 months ID are marked color

[Ramu_i]

Hi All,

Emp data is there, Joining date, DOB,Name,ID,Place ...

Based on the joining date emp entire row will indicate the color.

Input:

Emp ID	EMP Name	Joining Date	Pkg	Place	DOB	Qualification	MGR	who is interviwing
1	A	01-05-2022
2	B	02-05-2021
3	C	03-05-2020
4	D	04-05-2019
5	E	05-05-2022
6	F	06-05-2012
7	G	07-05-2022
8	H	08-05-2022
9	I	09-05-2015
10	J	10-05-2020
11	K	11-05-2021

Required Output:

Thank you.

Ram

[durgesh22 · Accepted solution]

@Ramu_i 

Use below expression in background color expression in column properties of table for all the columns.

if (Date#(Joining_Date,'DD-MM-YYYY')> AddMonths(today(),-1) and Year(Date#(Joining_Date,'DD-MM-YYYY'))=Year(today()),Yellow())

[durgesh22 · Accepted solution]

Adjust date range as per your requirement