Answered

Add one hour to the current time inside a DateTime field

(0) Share

Report

Posted on by johnjohn123

3,514

We have 2 fields of type Date-time named; BreakStartDate & BreakEndDate. for the BreakStartDate i set the default value for the Hour drop down to be "Hour(Now())". While for the BreakEndDate i specify the Hour to be "Hour(Now())" + one hour as follow:-

but my above formula will not add one hour to the Hour drop down .. any advice please?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@johnjohn123

Use the DateAdd function, eg

DateAdd( yourDateTimeValue, 1, Hours)

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Anonymoushere what i tried `Hour(DateAdd(Now(),1,Hours))` but the hour will always be shown as 00

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
@johnjohn123

I don't play around with Time much so I had to check out a form I'm currently working on.

To me, it looks like the Hrs & Mins dropdowns use Text type data and not numbers so you need to convert to Text to show these values. The hint is to look at the Items property and you'll see what I mean.

So BreakStartDate hours dropdown should be

Text(Hour(Now()), "00")

and, BreakEndDate hours dropdown

Text(Hour(Now())+1, "00")

See if that works for you?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Anonymousthis worked for me thanks

Was this reply helpful? Yes No