convert todays date into the day name

[cstafford]

I am looking to convert todays date into the day name. Is their a way to do this with Alteryx?

[MarqueeCrew]

DateTimeFormat([date],"%A")

 that will give you the day off the week, like Saturday.

 Cheers,

 mark

[cstafford]

I think I am close, but I cannot get the day to populate; it is returning Null. See attached

[MarqueeCrew · Accepted solution]

@cstafford ,

your [date] field is now a string.  If you want to know today's date,

DateTimeFormat(DateTimeStart(),"%A")

 cheers,

 mark

[AbhilashR · Accepted solution]

@cstafford - you could use this formula instead of a two step process: 

DateTimeFormat(DateTimeAdd(DateTimeNow(),1,'days'),'%A')

[cstafford]

Thanks!

[MarqueeCrew]

You're welcome 😀