web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Convert Number to Date

Power Apps

Answered

Convert Number to Date

(0) Share

Report

Report

Posted on by VDI

337

I am trying to convert Number to Date Time.

I am fetching data from SQL Server and Date column is type of number and I want to make it as Date in PowerApps.

SQL Server Date column values,

21540101 000000.000

20210527 124903.000

Expected result in PowerApps,

01/01/2154 000000.000

27/05/2021 124903.000

How can I do this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@VD
This will give you the date in PA
Date(Value(Left(yourDate,4).Text), Value(Mid(yourDate,5,2).Text),Value(Mid(yourDate,27,2).Text))

Was this reply helpful? Yes No
VDI 337 on at

Like (0)

Report
Copy link

Link copied!

@CNT , Thanks for help.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@VD Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@VD If you problem is solved,

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No

Join the conversation