convert date
formatDateTime(
addSeconds(
addDays('1899-12-30', int(items('For_each_2')?['Date'])),
int(86400 * (float(items('For_each_2')?['Date']) - int(items('For_each_2')?['Date'])))
),
'yyyy-MM-dd HH:mm:ss'
)
-------–---------------------------------
formatDateTime(
addSeconds(
'1899-12-30T00:00:00',
int(
mul(
float(
string(
items('For_each_2')?['Date']
)
),
86400
)
)
),
'yyyy-MM-ddTHH:mm:ss'
)
-------------++------------------------------------------------
formatDateTime(
addSeconds(
addDays(
'1899-12-30',
int(
first(
split(
string(items('For_each_2')?['Date']),
'.'
)
)
)
),
int(
mul(
float(
concat(
'0.',
last(
split(
string(items('For_each_2')?['Date']),
'.'
)
)
)
),
86400
)
)
),
'yyyy-MM-ddTHH:mm:ss'
)
------–----------------++++++--------
="W" & TEXT(WEEKNUM([Date1],2),"00") & " " & YEAR([Date1])
------------------
="W" & RIGHT("0" & INT((DATE(YEAR([Date1]-WEEKDAY([Date1]-1)+4),1,3) - ([Date1]-WEEKDAY([Date1]-1)+4)) / 7) + 2),2)
& " " & YEAR([Date1])
----------++++++++--------------
concat(
'W',
padLeft(
string(
weekOfYear(
<your_excel_date_conversion_expression>
)
),
2,
'0'
),
' ',
string(
year(
<your_excel_date_conversion_expression>
)
)
)
No comments