Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #46: Formatting a Date from an Integer

Shaktikdhar
8 - Asteroid

Pic1.jpg

Neeraj1584
8 - Asteroid

Challenge #46

Sanz_shetty_115
8 - Asteroid

Please find the attached output

Maxine
8 - Asteroid

My solution to Challenge 46

OlonJohnson
5 - Atom

File attached

 

1. Using formula to replace "1" and "0 with "20" and "19":

 

IF Substring([date],0,1)=='1'
THEN ('20' + Substring([date],1,9))
ELSE ('19' + Substring([date],1,9))
ENDIF

 

2. Changing string to readable date format, then changing column to date type using Select tool:

 

DateTimeParse([date_new],"%y%m%d")

 

3. Validation using formula and filtering for mismatches (column=1) in joined table on legacy table date columns:

 

IF [DateTime_Out]!=[date_new]
THEN '1' ELSE 0
ENDIF

 

 

VMSALDANA
8 - Asteroid

solution proposal attached

Raj
15 - Aurora

solved!

LuisLeon
8 - Asteroid

Solution!

AnkitaDutta22
7 - Meteor

done

 

thkjoseph
7 - Meteor

done