You searched for the word(s): 12
-
The today function just returns the date. You can test these things with calculated values. The syntax will be different for a condition - I didn't know that's what you were doing, and thought you'd be pasting this into the function editor for a rule. For a condition, change the first dropdown to "the expression" and use: ...
-
See above screenshot, did not work when Publish it, at that moment it gave error.
-
Ok, and does today() include the Time component? If so, does that mean I should make it translate(today(), "-", "") > 20201205 (since even 12/5/2020 12:01 AM will be greater) and I want it to "pass" the test as soon as it's 12/05 ?
This did not work upon Publish time, it then said error
-
Oh, I'd probably use a translate formula and just turn the date into numbers: translate(today(), "-", "") > 20201204
-
How can I test in an expression if today is after december 4th, 2020? I couldn't find this from googling! sorry! and thank you for looking at my question.
-
We are using on-premise sharepoint, managed by our company.
I am using Cognos too and it can read an xml file but I have never tried an xml file from sharepoint in Cognos. Cognos creates own xml files with report metadata.
-
Right - so that's the trouble with a repeating structure. But you are constrained by the limits of SharePoint - you can't have as many columns as they want. If you used a form that submits to SQL, you'd be ok - Or, I imagine some reporting tools could read the XML file data into a report that could be exported. Do you use on-prem or ...
-
Thnx Hilary I will try that. Business requires the reporting too so I have to find a hybrid solution I guess. If I can’t get those 7 files in excel I can’t report them too..
-
Here's a sample form I had in my files - right click the linked file, save locally. Right click the saved file and select design, then you can preview. In this sample there is only one "answer" field, using option buttons, but you could easily extend that to add all 7 of your fields. I use default data to include rows by default, and ...
-
Hi Hilary,
Many thanks for your response.
Can you give a little more explanation on library form and that idea to use repeating structure for the 7 standart fields?
Best Regards