Odd one. Moving data from a csv in one citrix session into an xls in another citrix session so I can analyse using pivots and vlookup, but more importantly save & share the data (can't on first citrix, systems eh).
When done the date field gets muddled from ddmmyyyy to mmddyyyy format.
This means also the biggest value is 12/12/yyyy ie there are no day values 13-31 which is statistically improbable given that I'm looking at 5000+ customers last visit dates for a venue open 364 days a year.
Is there any pre-work (formatting) i can do in the first citrix session to ensure I get the correct data across to the xls file in the second citrix session?
Caveat - it might also be a flaw in the database I'm reporting on, however one customer I've checked on both the csv & xls has a last visit 28/10/16 (csv) which ends up showing as 10/12/2016 on the xls.
Odd one. Moving data from a csv in one citrix session into an xls in another citrix session so I can analyse using pivots and vlookup, but more importantly save & share the data (can't on first citrix, systems eh).
When done the date field gets muddled from ddmmyyyy to mmddyyyy format.
This means also the biggest value is 12/12/yyyy ie there are no day values 13-31 which is statistically improbable given that I'm looking at 5000+ customers last visit dates for a venue open 364 days a year.
Is there any pre-work (formatting) i can do in the first citrix session to ensure I get the correct data across to the xls file in the second citrix session?
Caveat - it might also be a flaw in the database I'm reporting on, however one customer I've checked on both the csv & xls has a last visit 28/10/16 (csv) which ends up showing as 10/12/2016 on the xls.
Confused? Me too!