First day of the year

[Thombe]

Hello everyone,

First of all, sorry for my english.

I have the column [DATE_ENGG] type DateTime like YYYY-MM-DD HH:MM:SS

I need to create a filter to keep only raws >= at the first day of the year.

I tried this 

ToDate([DATE_ENGG]) >= DateTimeFormat([DATE_ENGG],"%Y-01-01 00:00:00")

But it doesn't work :)

If someone can help me, i'm very grateful, thank you! 

[alexnajm]

ToDate([DATE_ENGG]) >= ToDate(DateTimeFormat([DATE_ENGG],"%Y-01-01"))

If it's already in DateTime, try removing the "00:00:00" part at the end and adding another ToDate!

[Thombe]

Hello Alexnajm,

Thank you for your fast reply, unfortunately all my raws are going on "true".

Some exemple of the column :

 

Thank you

[alexnajm]

@Thombe can you send a screenshot of the metadata confirming it is set as a DateTime data type?

[Thombe]

 

Cordially

[binuacs]

@Thombe Are you looking for the output that is greater than the first day of the current year or the first day of the DATE_ENGG field? 

[alexnajm · Accepted solution]

Oh the formula is working correctly - currently it's saying that the DATE_ENG date should be greater than the first day of the year OF THAT YEAR. You likely want this:

ToDate([DATE_ENGG]) >= ToDate(DateTimeFormat(DateTimeToday(),"%Y-01-01"))

[Thombe]

Thank you everyone, i learn a lot of thing with your answers, have a good day :)