Hello,
I have a report I am trying to build with multiple dates, but I am having an issue where the dates are showing the time stamps at the end of the date (i.e. 1/1/2016 12:00:00 AM).
I am using a filter with a Join to show all dates for the listed PO number.
When I try to use the Excel short date format I am still seeing a time stamp.
Does anyone have any suggestions?
Here is the filter I am using:
=NL("Filter","Purchase Header Archive","Document date","no.",$H7)
Thank you in advance for the help!
Date
Votes
4 comments
-
Jet Reports Historic Posts I sometimes used the TEXT function to give just the format required:
=TEXT(NL("Filter","Purchase Header Archive","Document date","no.",$H7),"dd/mm/yyyy") -
Jet Reports Historic Posts I sometimes used the TEXT function to give just the format required:
=TEXT(NL("Filter","Purchase Header Archive","Document date","no.",$H7),"dd/mm/yyyy")
Hello Teresa,
I forgot to mention that I tried to use the TEXT function already, but I am still seeing the time stamp (the field is not being formatted to just dd/mm/yyyy).
Thank you for your suggestion!
Are there any further suggestions? -
Jet Reports Historic Posts Can you attach the report and indicate the problem cell? It's helpful to see the problem in context.
-
Jet Reports Historic Posts Try:
NL("Filter","Purchase Header Archive","=TEXT(NF(,""Document date""),"dd/mm/yyyy"")","no.",$H7)
Please sign in to leave a comment.