How to transform a date-time input and out put a date equal to the first of the month

  • 27 December 2020
  • 2 replies

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?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 5
Badge +5

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?

Userlevel 7
Badge +10

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