think about using Dateparse where you create a calculation with the "format" for the source date then in wrap if in Str()
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
1 of 1 people found this helpful
You could add a separate data source that lists all the dates in it (e.g. an Excel Spreadsheet with all the days from the beginning to the end of your range of interest, one date per row)....an independent calendar of sorts. Then, either cross join or blend the other data sources to this calendar source using the date fields of interest as the join fields. Note, the independent calendar needs to be the primary source in the join or blend for this to work.
This would be great . I tried doing the same however I was not using calendar as the primary source so I guess this is why it hasn’t worked. Will try this. Thanks!