SOLVED
Home

Format Date in header and footer

%3CLINGO-SUB%20id%3D%22lingo-sub-189400%22%20slang%3D%22en-US%22%3EFormat%20Date%20in%20header%20and%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189400%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20like%20to%20stamp%20PDFs%20of%20excel%20docs%20with%20the%20current%20time%20and%20date%20via%20the%20footer%20(or%20header).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22insert%20current%20date%22%20function%20inserts%20the%20date%20in%20my%20system's%20default%20(DD%2FMM%2FYYYY)%20but%20I%20would%20prefer%20if%20I%20could%20customize%20it%20per%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20how%20this%20would%20be%20possible%3F%20TIA!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-189400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-284227%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Date%20in%20header%20and%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-284227%22%20slang%3D%22en-US%22%3EOnly%20VBA%20could%20help.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189486%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Date%20in%20header%20and%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189486%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189472%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20Date%20in%20header%20and%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189472%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Joe%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20that%20there%20is%20no%20option%20%3CSPAN%20class%3D%22%22%3Eto%20change%20the%20format%20through%20the%20Current%20Date%20and%20Current%20Time%20elements.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThey%20always%20give%20you%20the%20date%20and%20time%20based%20on%20the%20default%20date%20format%20of%20the%20OS.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20format%20will%20not%20change%20unless%20you%20changed%20the%20%3CSPAN%20class%3D%22%22%3Edefault%20date%20format%20of%20the%20OS.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ERegards%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Joe Cangelosi
New Contributor

Hi everyone,

I like to stamp PDFs of excel docs with the current time and date via the footer (or header).

 

The "insert current date" function inserts the date in my system's default (DD/MM/YYYY) but I would prefer if I could customize it per document.

 

Any idea how this would be possible? TIA!!

3 Replies
Highlighted
Solution

Hi Joe,

 

It seems that there is no option to change the format through the Current Date and Current Time elements.

They always give you the date and time based on the default date format of the OS.

The format will not change unless you changed the default date format of the OS.

 

Regards

 

Highlighted
Thank you!
Highlighted
Only VBA could help.
Related Conversations