Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Bulk update data type DateTime to DateTimeZone with LocalNow Applied

Hi all, I've found a blog historically that allows you to bulk update all datetime columns to date only using the below code:   #”Convert Date” = Table.TransformColumnTypes(#”Changed Type”, List....
Need Help
slorin's avatar
slorin
Super User
3 years ago

Hi

Try

= Table.ReplaceValue(
   PreviousStep,
   null,
   null,
   (x,y,z)=>
       if x is date or x is datetime or x is datetimezone 
       then DateTimeZone.ToLocal(DateTimeZone.From(x)) 
       else x,
   Table.ColumnNames(PreviousStep)
)

 

Stéphane