Change Data Type

rkrt1

New member
Joined
Jul 24, 2022
Messages
9
Reaction score
0
Points
1
Excel Version(s)
2021
Hi Dear Fellows

Need some help.

Want to change the data type of the column in red to date type. Currently its Integer.
Anybody can please advise how it can be achieved in M-Code ?

Thanks

1666775411774.png
 
You'd use type date rather than Int64.Type but it doesn't look to me like your field actually contains a date.
 
Have you tried changing the
Int64.Type
to:
type datetime
?

I'd like to see what the data in that column looks like at the Promoted Headers step.
 
A guess, maybe starting from this:
1666783701544.png

you want this:
1666783767277.png

or this (since you took the whole number portion):
1666783848756.png
 
Back
Top