Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Date converting

    Posted Mar 28, 2022 04:31 PM

    Hi folks, probably it is very easy to fix, but Date Converting is a nightmare to me in Power Automate.

    I am trying to get two dates from an Excel file that is generated from MS FORMS>

    All other dates that the users are inserting are OK, I can get it, but those that are generated automatically, I can't.

    This the format:

    And the Flow I am trying to run to get the date on the DD/MM/YYYY format.

    Any tips, tricks or formulas will be appreciated.
    many thanks.


    ------------------------------
    Ricardo Carneiro
    SharePoint Consultant
    838322435
    ------------------------------


  • 2.  RE: Date converting

    Top Contributor
    Posted Mar 29, 2022 01:29 AM
    Dates in Excel are decimal numbers of days since midnight UTC on 1 Jan 1900. You can use the addDays() function to get the UTC date then convert to your local time zone.

    ------------------------------
    Will Page
    Technical consultant
    Christchurch, NZ
    ------------------------------



  • 3.  RE: Date converting

    Posted Mar 30, 2022 05:27 AM
    Unfortunately dates in the UK and anywhere else using a daylight saving scheme are much more complicated as the difference between UTC and local will be different at different times of the year

    ------------------------------
    Guy Boswell
    Care for the Family
    Newport
    02920810800
    ------------------------------