Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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