Format date YYYYMMDD as "integer"

[gnmq]

Hi,

I would like to check how can I convert a date field to an integer field?

For example, formatting date "20190131" AS integer "20190131"

The original date format is date-time, and I have formatted it with "Date" function to extract the date in format "YYYYMMDD".

Load 

Date(EffectiveDate, 'YYYYMMDD') as Date_Key

Resident TableA;

Updated solution:

=> Convert Date to Text then Integer

Load 

Num#(TEXT(Date(EffectiveDate, 'YYYYMMDD'))) as Date_Key

Resident TableA;

[jonathandienst · Accepted solution]

I am not sure why you would wan to do this, but probably:

Num(Text(Date(EffectiveDate, 'YYYYMMDD'))) as Date_Key

[gnmq]

Hi, thanks for the reply. I tested your method but it didn't work.

The output returns blank instead.

NUM(TEXT(DATE(EFFECTIVE_DATE,'YYYYMMDD'))) AS DATE_KEY

[gnmq]

Hi Jonty,

I retested your method with num#() and it works! Thanks so much 🙂

[jonathandienst]

You  are absolutely correct - my bad.😀

[mkamal]

I thought Num# was for interpreting and Num was for changing a format.  So why does Num# work in this case and Num does not?