Model - If date or timestamp of a dimension is empty insert current date or timestamp

[oliverschultze]

Hello together,

we want to calculate the difference in days between two date fields and the difference in hours between two timestamps here. But there is no option to insert the current date/timestamp in the story? How we do that?

Sometimes its possible that one datefield or timestamp is empty. In this case we want to use the current date or timestamp. Then when we try to insert the formula date a - date b it says "Formula could not be computed. Need to specify property for a hierarchy dimension. How to do the calculation?

BR/

[N1kh1l]

@oliverschultze 

Unfortunately there is no standard date/time function for current date supported in Story calculation.

Nikhil