Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

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...

tringuyenminh92
9 years ago
Hi Anonymous,

Have you tried compare 'opportunities'[Created].[Date] with Date(Value(YearString),value(MonthString),value(DayString))

tringuyenminh92

Memorable Member

9 years ago

Hi Anonymous,

Have you tried compare 'opportunities'[Created].[Date] with Date(Value(YearString),value(MonthString),value(DayString))

Anonymous
Not applicable
9 years ago

hi tringuyenminh92

yeap... that seemed to have worked...

Column = if(or('opportunities'[Created].[Date]=DATE(2016;12;6) ;'opportunities'[Created].[Date]=DATE(2016;12;7));"found";"not found")

funny though because when I compared with a dd/mm/year format,it didn't seem to complain..

is there a way that I can set by step calculate a formula like excel to see what the formula does?
- tringuyenminh92
  Memorable Member
  9 years ago
  I'm sorry but I don't know how excel behaves. Could you please show me some information or pictures with description for your expectation?
  - Anonymous
    Not applicable
    9 years ago
    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

Related content