Formula for shipping date

[Ronal_bal]

whenever the system a date at which month is beginning I need to add that date to the existing field. 


Example,
Current system date is 2022-07-01


Shipping date 
2022-07-01 

when current system date is 2022-07-19

No need to add that to the 'shipping date' field.

[IraWatt]

Hey @Ronal_bal,

Not sure I fully understand what you want to achieve. Could you give an example input table and what you expected output table would look like? 

[Luke_C]

Hi @Ronal_bal :

you can validate the below logic by setting the 1 to 19 and seeing the formula populate todays date.

if DateTimeDay(DateTimeNow()) = 1 
Then DateTimeNow()
Else Null()
Endif

More info on datetime formulas: DateTime Functions | Alteryx Help

[Ronal_bal]

I attached the example here, there are two use cases, @IraWatt 

[IraWatt · Accepted solution]

Hey @Ronal_bal,

Here's one way to do this:

The generate rows tool has a formula which will generate month dates till the current month using the DateTimeNow() function

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353 

Any questions or issues please ask :)
HTH!
Ira