Wrong date in header when exported to PDF

[lofgren]

Hello,

I have a small problem with a part of the code I made and I need some help.

So, I have a code that exports a sheet as PDF. The following line is part of this code (it simply writes Production and today date in header):

Please Login or Register  to view this content.

Today, a colleague of mine used the entire macro in order to export a pdf, but instead of "Production 24.03.2021", the pdf was exported with "Production 23.03.2021" in header.
Any idea why something like this happened? Do I need to change something with this part of the code Format(Date, "dd.mm.yyyy")?


Thank you.

[rollis13]

Did you check the PC's date&time ? was it right ? There is no error in your code so Date is Date.

[lofgren]

I will check my colleague's pc date & time, since I know that we don't have the same regional settings.
Thank you rollis13, for confirming that the code is ok