Hello friends how are you? My question is the following:
I need to calculate the number of days remaining to end the year from a given starting date. Does anyone know an expression?
I have thought of the following solution but it seems unsafe to me since the date formats are different in Latin America than in the US and depend on the devices.
TOTALHOURS(
DATE(
CONCATENATE(12,"/",31,"/",YEAR([Date]))
)-[Date]
)/24
In much of Latin America the date is written like this, Day,"/",Month,"/",Year
My fear is that by concatenating backwards the calculation will go wrong.
Does anyone know a better solution. Thank you
Solved! Go to Solution.
I believe date string literals in Appsheet expressions must always be entered in the mm/dd/yyyy format, no matter what a particular user's regional format is. So I think your expression is safe.
I believe date string literals in Appsheet expressions must always be entered in the mm/dd/yyyy format, no matter what a particular user's regional format is. So I think your expression is safe.
Thank you for your Answer Marc
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |