Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
PangHC
13 - Pulsar

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?

PangHC
13 - Pulsar

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
Top Solution Authors