Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following formula which should give a date but instead it gives a number...
=if(GetCurrentField("period")='Week',[Publish Date week],[Publish Date month forum topics])
Do you know how to ersolve this ?
thks,dani
=if(GetCurrentField("period")='Week',Date([Publish Date week]),Date([Publish Date month forum topics]))
=if(GetCurrentField("period")='Week',Date([Publish Date week]),Date([Publish Date month forum topics]))
use this:
if(GetCurrentField("period")='Week',Date([Publish Date week],'MM/DD/YYYY'),Date([Publish Date month forum topics].'MM/DD/YYYY'))
you may probably use the Date format function at the script level to avoid the function being invoked when the chart is rendered.