you can probably format to a DATETIME and then to ...
# suitescript
c
you can probably format to a DATETIME and then to DATE