I have start and end date for an event. I would like to find what the mid point time period between these dates is.
Is there a formula I can use to do that?
Hi @RoopaliB ,
You can create a number formatted line item for mid point between the dates ( i.e. (End date - Start date)/2) and add this to the start date to get mid date.
Please find the snapshots below
Hope this helps.
Thanks
Hi @Jitendra.Vishnolia
This works. Thanks!
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
Module 1 : UID * FCST - source Module 2: FCST - Mapping Module 3: UID * Time Range- Target formula used in module 3 module1.line item[lookup: module2.timeperiod]
