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

All responses (8)

Answers (1)

CU20080932-1 99 on at

Like (0)

Report

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

@Expiscornovus PFA the excel file

New Microsoft Exc...
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

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

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).
CU20080932-1 99 on at

Like (0)

Report

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

@Expiscornovus outputs of the List row present in table action also showing wrong date only
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

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

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?
CU20080932-1 99 on at

Like (0)

Report

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

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

Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

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

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?
CU20080932-1 99 on at

Like (0)

Report

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

@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
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

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

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?