TrimRight with wild card?

[mgirdwood]

Hi everyone

I am trying to use trimright to remove a specific number characters;

TrimRight([Ten-Minute Timeline],":*0:00")  where the fifth character from the right needs to be a wild card to catch the minutes.  When i run it it strips the last  4 characters but leaves behind the number of minutes.  Is there a way to set this  ?

Input

2023-03-01 09:40:00
2023-03-01 08:10:00
2023-03-01 08:20:00
2023-03-01 07:50:00

2023-03-01 09
2023-03-01 08
2023-03-01 08
2023-03-01 07

Thanks

Mark

[ShankerV]

Hi @mgirdwood 

One way of doing this.

[binu_acs]

@mgirdwood Basically the data is in DateTime format, if you want to only date part just update the dataType to Date

[Christina_H · Accepted solution]

You could keep it in DateTime format by using DateTimeTrim([Input],"hour")