how to convert set variable output (0.0288645833333333) to date format ((6/23/2023 9:39:00 AM))

(0) Share

Report

Posted on by CU20080932-1

out is in the format of 0.0288645833333333.

we want to convert it to date format (6/23/2023 9:39:00 AM)

@Expiscornovus

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Yallaling,

Not really recognizing that format, tbh 😁. I have seen time stamps being formatted as decimals, but not date and time.

Can you share a bit more details about where you are getting this value from (which system and what are you using in your set variable action)? Or do you know what the name is of this format?

Was this reply helpful? Yes No
CU20080932-1 99 on at

Like (0)

Report

@Expiscornovus We are getting this input form excel list as below

the actual date format in excel is '6/23/2023 9:39:00 AM' but we are getting as a decimal format

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Yallaling,

Are you using the ISO 8601 format in the settings of that list rows present in a table action? If not, can you select that format and try again?

Was this reply helpful? Yes No
CU20080932-1 99 on at

Like (0)

Report

@Expiscornovus after changing the ISO 8601 format in the settings we are getting date as a output but date is wrong

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Yallaling,

Can you check in the outputs of the List row present in table action and see if the dates show up correctly over there?

Was this reply helpful? Yes No
CU20080932-1 99 on at

Like (0)

Report

@Expiscornovus outputs of the List row present in table action also showing wrong date only

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Yallaling,

Can you share a screenshot of the value in your excel file column/row? Also double check what is used in the fx field for the row/cell.

Are you using a specific number format in that column? (Generic or a specific date or time format?). If so, please share what that format is.

Below is an example how to check all these things in your Excel file (click on the gif to see it in higher resolution).

Was this reply helpful? Yes No
CU20080932-1 99 on at

Like (0)

Report

@Expiscornovus PFA the excel file

New Microsoft Exc...

Was this reply helpful? Yes No