You’re offline. This is a read only version of the page.
28
Hi,
I couldn't get this expression to work properly because the 'End Date' is 44815.3333333333 format
therefore it is not an integer therefore this expression is invalid. Please advice how can I edit this expression.
addDays('1900-01-02',formatnumber(item()['End Date'],'#0'),'MM-dd')
Hi @r0663664 ,
Use below expression:
| formatDateTime(addseconds('1899-12-30',int(formatnumber(mul(float(item()['End Date']),86400),'0'))),'dd-MM-yyyy hh:mm') |
Format datetime as per requirements.
If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.
Regards
Kaif
Hi @r0663664 ,
Please try:
addSeconds('1900-01-02',int(string(mul(mul(mul(item()['End Date'],24.0),60.0),60.0))))
Best Regards,
Bof
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
