In my report I have =NP("EVAL";"Blad2!$F$3") to get the date. I formatted this date as yyyymmdd.
It displays the date correctly in the cells but in the formula window it still shows dd/mm/yyyy instead of yyyymmdd.
How can I get it to display yyyymmdd in the formula bar? In A1 I have Auto+Hide+Values+Lock.
Date
Votes
6 comments
-
Jet Reports Historic Posts Official comment Hi Robbie,
So Jet can't control what their importing software does to the date format. I'm sorry, but I don't think that has anything to do with Jet. As far as Column A showing "Unhide", I'm guessing that is because you are using conditional hide in your report so you have column B of the report showing either Hide or Unhide in order to hide certain rows and have Hide+? in cell B1. After deleting column A, column B then becomes column A. Column B with Hide and Unhide in it doesn't get deleted even when you tell the Jet Scheduler to delete hidden columns because people often have Excel formulas that are dependent on the values in column B which would break if it were deleted. It sounds like their import software is unhiding the hidden columns so that column is then showing up. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Hi Robbie,
Jet can't control what Excel displays in the formula bar. I think Excel always displays things it detects as dates in the formula bar in the computer's date format. You can look around online, but I doubt there's any way to change that. Certainly it's nothing Jet can control.
Regards,
Hughes -
Jet Reports Historic Posts I have to deliver a file to my supplier and if they import the file I exported with scheduler the date displays as mm/dd/yyyy instead of the yyyymmdd.
I also have conditional hide in column be and after export it displays the unhide in column A, this should be hidden automatically. What i'm I doing wrong? -
Jet Reports Historic Posts Hi Robbie,
I don't know what you mean by them importing the file. What did they use to import the file? Most likely whatever software they're importing into has unhidden the column. As far as the date format, do you mean it displays as mm/dd/yyyy in Excel or in whatever software they've imported into? Does it display that way before or after the import?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
They use their own analysing software to read the file. After they imported the file the date show mm/dd/yyyy instead of yyyymmdd.
The column A is showing "Unhide" in all the rows when the scheduler exported the Values only workbook. -
Jet Reports Historic Posts Hi I deleted the conditional hide. Problem fixed ;)
Please sign in to leave a comment.