Hi,
I'm getting a mapping error with my dates because they are not formatted identically. How can I fix this without going in and mapping each date to one another manually?
Thank you
Pics attached
@neg177 !!!!
How are you? Great question.
So you'll want to create custom formats for each of those.
("8/18/2020") use ??M-D-Y??
and for 10/2/1010 use M-D-??Y
Screenshots below!
I'm well thank you for asking. I hope you are as well.
It doesn't take me to that Custom Mapping option like it sometimes does. Just takes me to the option to manually map the dates.
@neg177
Are you importing into a module or a list? If it's a module you should get that date format option. Also, are you using the model calendar or a fake calendar? If it's a fake calendar, you'll have to bring the date in as TEXT then format it and convert to a date. If it's a list, you're probably loading into a list property. If that's the case, I'd like to encourage you not to use list properties, a topic we can certainly discuss. Instead try to create a system module and load the properties there. The biggest benefit is that you can perform formulas on your properties as use them with LOOKUP and SUM. Calculate once, refer often.
If I'm way off, send me some more detail about what you're loading this data into. I'll get you to the finish line.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
