Forum Discussion

dhirata's avatar
dhirata
Frequent Visitor
1 year ago
Solved

Syntax error in custom function to covert UTC to Central Time

I have the following M code as a custom function in power query, and I'm getting a "Token ')' expected" error, but I don't see where a parenthesis is missing. Can you please help?  Function is suppo...
  • ronrsnfld's avatar
    1 year ago

    The error messages often point to something other than what they specifically indicate.

    Examining the code window can give you some hints.

    For example, there is no `mod` operator in PQ and you will see that it has a wavy red underline in the editor:

    You need to use the `Number.Mod` function.

     

    Also, if your computer itself is set to Central Time, there is a much simpler method to convert to local time (or to the local time of whatever a computer is set to (and it will take DST into account):

    // Function to convert UTC to Local Time)
    (ConvertUTCtoLT as datetime) =>
    let
        addTZ = DateTime.AddZone(ConvertUTCtoLT,0),
        toLocal = DateTimeZone.ToLocal(addTZ),
        localDateTime=DateTime.From(toLocal)
    
    in
    localDateTime