dateTime and other functions
dateTime and other functions
I need mont and year!. Yes, it can be calculated, BUT with errorrs or complicated!
FORMAT(secconds,"dd.mm.yy") or "MMM" or "YY" or "YYYY" etc...
RINT function works as round not int!????
String function missing: RIGHT(S,r) =substring(S, lenght(s)-r,length(s) !
And This: real numbers are OK in google table BUT dates are still wrong! Why set date format to "dd.mm.yyyy" and then transfer to "mm/dd/yyyy?
br B
1
vote
Bo Bri
shared this idea
-
Fabrizio commented
I have a similar problem.
Two Table:
MMDD
"0101", 0102,...
PRICE
58,59,....
Search in the Table One and Find Price Table Two,
But not add price.
Why?