Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
how below expression works? can anyone explain?
Num(if(month(today())>=2,date('06/02/'&year(today()),'dd/mm/yyyy'),date('06/02/'&year(today())-1,'dd/mm/yyyy')))
Thanks
Sony
Theoretical it will gives you a numeric value of a hardcoded date.
if this month if greater or Equal With february it gives you 06/02/2017, if not 06/02/2016.
I believe this won't effect. It may show - because Month(Today()) always return String and String never resemblance with Number.
yes I am getting null
but I want to get month end from that
Where do you want it, in a textobject? and what do you want to see, explain the Logic.
To clarify, This will work. But not really know for Which month you are going to have MonthEnd?
=if(Num(Month(today()))>=2,Date(MakeDate(year(today()), 02, 06),'DD/MM/YYYY'),Date(MakeDate(year(today())-1, 02, 06),'DD/MM/YYYY'))
Date() here might not be required that way. Could you explain what exactly you are trying to do? May be explain in plain English. I guess much simpler solution would be there.
its giving me result like below
0.00012394 something
Never give like that
I want to use this as variable
that value should be a monthend