Skip to main content
  • Home
  • Get Help
  • How Do I
  • How to transform a date-time input and out put a date equal to the first of the month

I am receiving data from a form (date/time format) and I need to transform that into a date equal to the first day of the date’s month so I can send to another system as the effective date of the transaction.  In this systems transactions always have the effdt of the first of the month, regardless of the date of signup.

For example:

Input date:  2020-11-06 11:27:13

I want to transform into:  2020-11-01  (the first day of November).

Is this possible to do?

Hey @4SocialChange,

what comes to my mind first is that you can use Paths (see here). You would just have to create 12 different paths for every month and create an if statement that makes sure when a date is for example in November, the field shows the first of November. Does that makes sense for you?

@4SocialChange 
Just checking in to see if you still need help with this? 

Terms & Conditions