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.
Solved! Go to Solution.
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?
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
I attached the example here, there are two use cases, @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