Forum Discussion
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
=calculate(
[Measure1],
Table1[startdate]<="20/02/15 12:00:00"
,Table1[enddate]>="2016/02/15 12:00:00"
,Table1[Application_date]<datevalue("2017/02/16")
,Table1[year] ="17/18"
)Any idea how I can work around this? Its crusical that the time is used as the records can change several times a day so we need to specify a time down to the second.
Any help appreciated
THnk I answered my own question, I used:
<Date(2017,2,16) + Time(12,00,0) which seems to have worked
4 Replies
THnk I answered my own question, I used:
<Date(2017,2,16) + Time(12,00,0) which seems to have worked
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
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)
