Remove Time from Date Time Last of Month

[Brook_G]

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?

[christine_assaad · Accepted solution]

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!

[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.