How can we help you today?

How can we help you today?

Formatting bug when using IIF

if you take the following statement, the spaces are intenional white spaces, and format it it does not format the IIF as nicely as the datediff

select 
	iif&#40;     rrbr.ColumnName = 'Test',    0,       1&#41;, 
	datediff&#40;       day,         getdate&#40;&#41;,       getdate&#40;&#41;    &#41;
from 
	recon.ReconResultsByRow as rrbr

select 
	iif&#40;
	rrbr.ColumnName = 'Test',    0,       1&#41;,
	datediff&#40;day, getdate&#40;&#41;, getdate&#40;&#41;&#41;
from
	recon.ReconResultsByRow as rrbr

eugenen November 12, 2013 06:32

0

Comments

1 comment

This'll be fixed in the next release of prompt (and is also in the private build I mentioned on your other post)

Aaron L November 12, 2013 13:49

0

Add comment

Please sign in to leave a comment.