Compare Dates (Verbose) 📅📅
Compare Dates (Verbose) [Category: Conversion]
This function provides a summary of how 2x input dates compare (and also includes simple 'convert to date' logic to aid the analysis).
Output options are:
- Exact match
- Incomplete - Date 1 is missing (or not a date)
- Incomplete - Date 2 is missing (or not a date)
- Incomplete - Both dates are missing (or not a date)
- Close - Day & Month match
- Close - Month & Year match
- Close - Day & Year match
- Other difference
See below for the function definition (not there are several variables defined outside of this preview), as well as some sample results for some test input values (highlighted cells):
If you want to simplify these definitions you can add another function block (specifically a 'split' function configured with hyphen as the split value and '1' for the element to return) after this one to retrieve just the simple summary.
Compatibility:
This function is compatible with all instances of Data Studio from v2.1.11 onwards.
[dl-button|Download|https://us.v-cdn.net/6031645/uploads/2H1G8YYME9RO/compare-dates-28verbose-29.dmx]
Comments
-
Rookie here. I downloaded the JSON files. But how do I use them in our Aperture?
0 -
You can import dmx files into a Space following Docs here:
0 -
Thanks. I had trouble finding the DMX file, I must have hit the wrong link somewhere and got JSON files, but I have the DMX file now. I'll use those instructions to pull it in.
tanks again!
0 -
Well this is unfortunate. I don't have the option to import on my account. I'll contact admin and see if they can either give me the access or import it for me.
0
