This project has moved and is read-only. For the latest updates, please go here.

Current Date and Time in Excel Header

Jul 9, 2013 at 9:45 AM
Edited Jul 9, 2013 at 9: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.

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