Current Date and Time in Excel Header

Jul 9, 2013 at 8:45 AM
Edited Jul 9, 2013 at 8:46 AM
Hello All,

I am trying to use Current Date and Time in header, but it appears as a text like "&[Date] &[Time]". When I click on header then it displays date and time values.

Any idea how to get rid of this? as I would get current date and time values as soon as I open it up.

Regards,
Pravin
Jul 9, 2013 at 9:11 AM
Hey, I got the solution for this, I was going in wrong direction, used ExcelHeaderFooter.CurrentDate + " " + ExcelHeaderFooter.Currentine and its working perfectly.

Thanks