Hi All,
I have a datasource that stores events for our door access system.
Unfortunately, the event date/time, is stored as a single date time value in one DB field.
Is there some way I can take this and generate an NL sheets function that only does one sheet for each day?
I tried simply doing an NL sheets function using that field, and limited it to just a few days, but given the amount of time it took before it stopped responding, I suspect it was doing one sheet for every single time stamp it found.
The only other solution I can think of, is to do a batch task, whereby the date range is passed to a sub report as the date filter, so rather than having one sheet for each day, I have one workbook for each day.
Does anyone have a better way/suggestions?
Many thanks!
Eds
Date
Votes
2 comments
-
Jet Reports Historic Posts You might try to isolate the date part with an excel function.
NL("Sheets","<Table>","=TEXT(NF(,""<DateTimeField>""),""dd-mm-yyyy"")","<DateTimeField>","01-01-15..06-01-15")Where <names> need to be replaced by real names.
No syntax check done…
rmw -
Jet Reports Historic Posts Thanks for the suggestion.
I ended up harcoding in some forumlas to get a list of dates for any given month, then used an NL sheets on that range of cells.
Probably not the cleanest way of doing it, but has achieved what I needed :D
Eds
Please sign in to leave a comment.