Converting Date/Time field to Date Field

[Dinu1]

Hi,

I am looking to match the Date/Time field value in the Accounts module to a new date only field within the Accounts Value.

Ex: New account is created now, therefore my Date/Time filed value will be : 06/07/2021 11:27.

However, I am trying to create a workflow to match only the date like 06/07/2021. As a result, I don’t need the time value in my field.

Please someone could help with this.

Thank you

Best Regards ,
Dinu

[vijay1992]

Hi @Dinu1,
please see this post maybe it’s helpful to you:-

Workflows fail due to bad date

Any date function I add to a workflow makes the workflow fail with an error: Bad date 2019-05-01 19:45:00 for format m/d/Y H:i As an example a formula I am using is: {addMonths(Y-m-d; {P0}; {P1})} where P0 is the Start Date Raw Value and P1 is an integer But the same thing seems to happen with any date function I try. Any ideas? Thanks.

How to create the timer (date and time ) field in Case module in suite CRM

Hi , Is there any way to create a custom field of date and timer ? timer should run each each second or minite , If is possible kindly share . Thanks Sandeep

[Dinu1]

Hi @vijay1992,

Thank you for your support. I will have a look.

Best Regards,
Dinushan