Forum Discussion
problem with dates and evaluating a formula
hi i have created a new column and Im doing some checks with date fields.... for some reason they don't seem to work. I'm tryind to identify records that were created either the 6th or 7th Dec 2...
Hi Anonymous,
Have you tried compare 'opportunities'[Created].[Date] with Date(Value(YearString),value(MonthString),value(DayString))
never though I'd hear that ;-) (don't know how excel behaves) but I'll give you an example.
dummy formula
=IF(5+7+9+12=2;"OK";"no OK"). then you select 'evaluate formula" and excel goes step by step evaluating the formula so that the user can "debug" it.
it is much like running a piece of programming code step by step and being able to see what the code does
As my perspective, i think no. maybe someone in this community that they could have solution for your concern.