Formula for shipping date

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.

Datasets

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

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

Screenshot 2022-07-19 131653.png

IraWatt

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

Workflow.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335