Converting Dropdown datetime from text value into number format

(0) Share

Report

Posted on by MAli_Ch

Hi,

I have a dropdown for date in my app where date is coming from my datasource and user can select the date. Now issue is I'm trying to add a condition where dropdown.selectedtext.value = date_num (Column in my DB for where I have converted datetime into integers e.g. 202311161354(yyyymmddhhmm)). Now I want to my dropdown value which has type text I want to convert it into integer type in the mentioned format in my condition. Plus I dont want to change datetime format in dropdown. I have also added below the SS of datetime value in my dropdown. The second SS displays the date format which I want for dropdown date to be.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MAli_Ch ,

Please try:

Int(Text(DateTimeValue("11/15/2023 1:31 PM"),"yyyymmddHHmm"))

Best Regards,

Bof

Was this reply helpful? Yes No
MAli_Ch 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-bofeng-msft.
Your solution worked out.

Was this reply helpful? Yes No