Remove Time from Date Time Last of Month

Hi! I have been trying to use the Date Time Last of Month function. The issue is that I do not need the time on there, but I don't see an option to just use the Last of Month without the time. I have tried the Date Time Trim function because I'm thinking that might be the key to fixing my issue. However, I am getting stuck on what to enter for dt, t in that function. Any advice?

Date Time

Accepted answers

Christine_Assaad

Hi @Brook_G

You can just wrap it with todate() similar to the attached screenshot. Hope this helps. Cheers!

All comments

Christine_Assaad

Hi @Brook_G

You can just wrap it with todate() similar to the attached screenshot. Hope this helps. Cheers!

Qiu

@Brook_G
How about simply change the Data Type to Date?

RobertOdera

Hi, @Brook_G

Please try the below and like + mark as an acceptable solution if it works for you.

So, from your use-case, you are likely either:

1. working with Time (E.g., 12:23:30) or

2. working with Date Time as an in-coming Text stream (E.g., 2020-12-25 12:23:30)

Check out the below. You can nest the bottom stream formulas in one formula tool, I just did them separately here for clarity of the treatments.

I have attached the workflow for your convenience. Cheers!

ForBrookG.yxmd

grazitti_sapna

Hi @Brook_G,

There are multiple ways you can do that:

1) you can use the todate function

2) You can simply change the data type to date

3) If the data type of output does not bother you, you can also use substring function.

I hope it helps.

Brook_G

Thank you @christine_assaad

This solution worked perfectly.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703