Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
i have a date field [CF Date de livraison] that is sometimes empty. I want to create a dimension named [Date prevue] where when the field [CF Date de livraison] is empty, it takes the value from the field [Date confirme].
Is it an if function and how is the syntax?
Thank you,
Lawrence
I would try an If Statement
If(isnull([CF Date de livraison]), [Date confirme])
Something like that.
If( isnull([CF Date de livraison]), [Date confirme],[CF Date de livraison]) as [Date prevue]
If( len(trim( [CF Date de livraison] )) > 0,
[CF Date de livraison],
[Date confirme]
) as [Date prevue]
Date(Alt( [CF Date de livraison] ,[Date confirme])) as [Date prevue]
Regards
Marco