Issue with Date

[#1]

Hi All, I have an excel file containing attendance records of all employees in the format specified below.

Employee #	Names	Team Name	Designation	Work status	01-Jan-16 Fri	02-Jan-16 Sat	03-Jan-16 Sun	04-Jan-16 Mon	05-Jan-16 Tue	06-Jan-16 Wed	07-Jan-16 Thu
1	Priya	IT	Analyst	Active	P	P	P	P	P	P	P
2	Priyanka	IT	Analyst	Active	A	A	A	A	P	P	P
3	Monika	Finance	Analyst	Active	P	P	P	P	P	P	P
4	Sarvesh	Admin	Analyst	Active	P	P	P	P	P	P	P

And I want it to load it in below format

Employee #	Names	Team Name	Designation	Work status	Date	Att_Value
1	Priya	IT	Analyst	Active	01/01/2016	P
2	Priyanka	IT	Analyst	Active	01/01/2016	A
3	Monika	Finance	Analyst	Active	01/01/2016	P
4	Sarvesh	Admin	Analyst	Active	01/01/2016	P
1	Priya	IT	Analyst	Active	02/01/2016	P
2	Priyanka	IT	Analyst	Active	02/01/2016	A
3	Monika	Finance	Analyst	Active	02/01/2016	P
4	Sarvesh	Admin	Analyst	Active	02/01/2016	P
1	Priya	IT	Analyst	Active	03/01/2016	P
2	Priyanka	IT	Analyst	Active	03/01/2016	A
3	Monika	Finance	Analyst	Active	03/01/2016	P
4	Sarvesh	Admin	Analyst	Active	03/01/2016	P
1	Priya	IT	Analyst	Active	04/01/2016	P
2	Priyanka	IT	Analyst	Active	04/01/2016	A
3	Monika	Finance	Analyst	Active	04/01/2016	P
4	Sarvesh	Admin	Analyst	Active	04/01/2016	P
1	Priya	IT	Analyst	Active	05/01/2016	P
2	Priyanka	IT	Analyst	Active	05/01/2016	P
3	Monika	Finance	Analyst	Active	05/01/2016	P
4	Sarvesh	Admin	Analyst	Active	05/01/2016	P
1	Priya	IT	Analyst	Active	06/01/2016	P
2	Priyanka	IT	Analyst	Active	06/01/2016	P
3	Monika	Finance	Analyst	Active	06/01/2016	P
4	Sarvesh	Admin	Analyst	Active	06/01/2016	P
1	Priya	IT	Analyst	Active	07/01/2016	P
2	Priyanka	IT	Analyst	Active	07/01/2016	P
3	Monika	Finance	Analyst	Active	07/01/2016	P
4	Sarvesh	Admin	Analyst	Active	07/01/2016	P

But the issue I am facing is with the date column. It is getting loaded in number format. I tried converting it into date format using date and date# function but couldn't achieve desired result.

I need your suggestions.

Thanks in advance

-Priyanka

[MarcoWedel]

Hi,

because I reveived date formats when reading the Employee # values I wanted to format them as integers.

One way to achieve this is the evaluate function. I guess Num() would also work. Another option could be to load the field as is and use number / change document format to define integer formats for this field.

hope this helps

regards

Marco