i need to add first day to 2021-12-

[nataliad18]

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

[binuacs]

Spoiler

[nataliad18]

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

[RolandSchubert · Accepted solution]

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]

Hi @RolandSchubert

They still dont work for me 😞 See screenshots attached

[nataliad18]

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]

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

[nataliad18]

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