Answered

Any date selected in or after April comes through as the date before

(0) Share

Report

Posted on by Rogan

As stated in the title any date I select in April or beyond comes through on the email as a day before. For example if I select 8/04/2024 it will come through as 7/04/2024.

Any date selected in Jan Feb or March comes through fine, maybe this is because its a leap year?

this is the expression i am using on the date in the email:

formatDateTime(outputs('Get_a_row_by_ID')?['body/crd73_fromfirstdayoff'],'dd-MM-yyyy')

any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Rogan ,

Actually I suspect the daylight saving for that … even if you selected the date column in dateverse as date only, the response is received in UTC as yyyy-MM-ddT00:00:00Z

What if think you can do is to use

ConvertFromUTC(

outputs('Get_a_row_by_ID')?['body/crd73_fromfirstdayoff'],’your specific time zone’,'dd-MM-yyyy')

Was this reply helpful? Yes No
Rogan 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am getting this message when trying to put that in as the expression.

This is what im putting in:
ConvertFromUTC(outputs('Get_a_row_by_ID')?['body/crd73_fromfirstdayoff'],’GMT’,'dd-MM-yyyy')

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
convertFromUTC( outputs('Get_a_row_by_ID')?['body/crd73_fromfirstdayoff'],'GMT Standard Time','dd-MM-yyyy')

Was this reply helpful? Yes No