Jet Hub Date Format

Hi, I am loading reports into Jet Hub for the first time.  The reports run fine when run from our normal server / folder environment however whenever I upload the files to jet Hub and run them the date format of the reports is changing and appears to run the reports in USA format of MM/DD/YY.  

I have checked my setup and excel and the Jet Hub login are all in UK format, I even tried putting in text strings for date so that they refer to a cell which converts the date to whatever format i want which is DD/MM/YY but still this does not work.

Can anyone help?


1 comment

Please sign in to leave a comment.