![]() [=IIf(Fields!Site_Type_Descriptors_Concept.Value= "GPI", (DateAdd("d",14,(lookup(Fields!Project_ID.Value,Fields!Project_ID.Value,Fields!Closing_Store_Milestones_Primary_Dumpster_Arrival_Date.Value, "Closing_Store_New_Milestones")))),(lookup(Fields!Project_ID.Value,Fields!Project_ID.Value,Fields!Closing_Store_Milestones_Primary_Dumpster_Removal. I can send to pdf, but that doesn't meet the need. Maybe writing for DATEADD needs to be different now? At any rate, despite it returning a report when I run it, the report Below is the code.īecause it has worked up until they upgraded their server, I can only assume the problem may be with the syntax. We are looking for a date picker that can be used on a Mac excel version 2019. The second one, Mini Calendar and Date Picker, only works for excel 2013 and older. Productivity downloads - Microsoft Excel by Microsoft and many more programs are available for instant and free download. Where date is present it returns the date, but apparently not with days added to it. Rich99 The first one you mentioned, XLTools, does not work for Mac. The report runs, but where the date is blank, it sometimes returns a strange date that doesn't exist (), or a blank. The problem has been narrowed down to a field with a nested formula where it is using a DATEADD feature, looking at two differently ![]() My Saas vendor upgraded to MS SQL Server '16 a week ago and now one of my reports in Report Builder will not export to Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |