Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

Compare DateTime to Text

Hi All,   I'm trying to manually specify a datetime to use in a formula but can't get it to work, I orignially used the datevalue function but have discovered it ignores the time.   My measure is...
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    9 years ago

    THnk I answered my own question, I used:

     

    <Date(2017,2,16) + Time(12,00,0) which seems to have worked

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

you can always use this as well

 

 

 < DATEVALUE("2017-02-16 12:00:00")

 

 

Not sure if that is any easier for you to create in your code

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
9 years ago

Phil_Seamark

 

That would have been a bit easier and was what I tried initially, however after much headscratching I found a section in the docs that confirmed it ignores the time element (strangely it still throws an error if you input an ilegal time)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi itchyeyeballs,

    DATEVALUE(date_text) 

    Yes, time information in the date_text argument is ignored according to the official article.

    As you have use a workaround to solve this issue, you can accept your reply as solution, this way, other community members would easily find the solution when they get same issues.

    Thanks,
    Lydia Zhang