how to change this '1.68834E+12 ' into date?
# suitescriptv
vennila ramasamy
08/04/2023, 7:40 AMhow to change this '1.68834E+12 ' into date?
b
battk
08/04/2023, 7:47 AMconvert it to a number first
s
Stuart Anderton
08/04/2023, 7:55 AMIf you are getting that as text then you can’t. Usually happens when data is loaded into Excel then saved as CSV. Go back to Excel and change column format to date.
v
vennila ramasamy
08/04/2023, 8:02 AMeven if i change , the customer dont remember to do it everytime i believe.the data is from customer now. anyother way?
b
battk
08/04/2023, 8:13 AMbattk
08/04/2023, 8:15 AMafter that, its number to date
s
Stuart Anderton
08/04/2023, 8:44 AMThat won't work if you only have 6 significant digits.
b
battk
08/04/2023, 9:22 AMtry it and then revaluate that statement
s
Stuart Anderton
08/04/2023, 9:47 AMReally? That's enough to get the date? Never thought of that!
v
vennila ramasamy
08/04/2023, 11:34 AMi could get the number as 1688342400000
but i dont get the date from this.
e
Edgar Valdes
08/04/2023, 3:49 PMShow your code
a
Anthony OConnor
08/04/2023, 4:54 PMv
vennila ramasamy
08/07/2023, 7:11 AMI could do it. Thank youall
3 Views