First question: Question about what date format to use
I imported a .csv file to jira and i need to find the difference between 2 dates. I keep getting invalid. I think its because I can't figure out the correct date format for dates in this format: 23/Jun/2022 04:38:13PM -0400
What is the right format? I think it starts dd/mmm/yyyy h:mm:ss AM/PM , but what about the -0400 which is just a GMT adjustment. Or is it easier to just get rid of the -0400? its 0400 is each field. if so what is the fastest way to trim that out?
My second question: i need a field that calculates off of another field.
if a need is less than or equal to 1 , I need it to be transformed into an S, if its more than 1 or less than or equal to 24, I need an M, and if its more tahn 24, I need it to be transformed into an L? This is some kind of IF statement right?
So if out is like this
Column 1. Column 2
.5 S
2 M
25 L
Bookmarks