Compare DateTime to Text

[itchyeyeballs]

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

[itchyeyeballs · Accepted solution]

THnk I answered my own question, I used:

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

[Phil_Seamark]

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]

@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)

[v-yuezhe-msft]

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