Alteryx Designer Desktop Discussions

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

date time

jonick1205
7 - Meteor

Good Day master i have this set of field with dd-month how can i call the date today if i have the format date below

 

Field 1

01-November

02-November

3 REPLIES 3
Pang_Hee_Choy
12 - Quasar

use formula tool to convert to date format  or datetime tool depend which one you more familiar with

datetimeparse([field1],"%d%B")

jonick1205
7 - Meteor

this field is from a table and i wanted to highlight the date today in create rule is that possible?

Pang_Hee_Choy
12 - Quasar

seem like you are using table tool. 

ok, by this way we can do reverse way.

 

convert today to string and compare it. 

DateTimeFormat(DateTimeToday(),"%d-%B")=[_CurrentField_]

Pang_Hee_Choy_0-1635917021173.png

 

Labels