Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

i need to add first day to 2021-12-

nataliad18
8 - Asteroid

Hi!

I have data in alteryx (see formula attached), but no matter what I do, I cannot add the day. I need it to be the first of the current month every run. I tried adding +"1", I tried to make another column and combine them, I tried everything and I cannot do it. Any help is appreciated.

Thank you!
Nat

nataliad18_0-1638529130020.png

 

7 REPLIES 7
binuacs
20 - Arcturus
Spoiler
binuacs_0-1638529820845.png

 

nataliad18
8 - Asteroid

Hi! this looks great but i dont have dateadd function?

 

nataliad18_0-1638530128278.png

nataliad18_1-1638530142543.png

 

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @nataliad18 ,

 

you can use 

 

DateTimeFormat(DatenTimeToday(), '%Y-%m-01'), this will return '2021-12-01' (or, next January, '2022-01-01').

 

The other option is, you use

 

DateTimeFormat(DateTimeFirstofMonth(), '%Y-%m-%d') , will give the same result.

 

Let me know if it works for you.

 

Best,

 

Roland

nataliad18
8 - Asteroid

Hi @RolandSchubert

 

They still dont work for me 😞 See screenshots attached

nataliad18_0-1638531499483.pngnataliad18_1-1638531504702.png

 

 

 

 

 

nataliad18
8 - Asteroid

Update: I changed the column to add a new one instead of rewriting an existing one, and then it worked. Have no idea why it was not letting overwrite correctly @RolandSchubert your solution worked, thank yoU!

binuacs
20 - Arcturus

Hi @nataliad18 it was not working because the data type size is set to 8

nataliad18
8 - Asteroid

oh, will keep in mind next time! thank you!

Labels