This message was deleted.
# questionsb
brainy-london-213
02/03/2022, 3:51 AMThis message was deleted.
c
clever-art-10420
02/03/2022, 6:41 AMAirtable formatting is not pulled across. just the raw value.
The way to do this atm is to create a formula field and apply your formatting through the datetimeformat function. the result isa string and comes across to stacker
clever-art-10420
02/03/2022, 6:42 AMso you’ll need to run DATETIME_DIFF() and then run the output into DATETIME_FORMAT() or whatever it is.
clever-art-10420
02/03/2022, 6:42 AMthat should work
s
square-fish-49882
02/03/2022, 5:17 PM@clever-art-10420 these are the 2 formulas I have currently, and these are resulting in an error. The DATETIME_DIFF() is working fine, it's the DATETIME_FORMAT() that is not working.
s
sticky-night-20812
02/03/2022, 5:19 PMYou cannot simply convert a number (duration) into a date, you need to add the duration to another date to get a “date” data, and then format it.
👍 1