Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I would like to import a string character as 01/01/2011 11:11:11 as a julian date in loading the script.
How can I do?
Thanks
Hi there,
there are some function, if you use it will show you the julian date. try ReloadTime in script or anyware in the text object properties so that you can see the time. Is this you want?
=ReloadTime()
Regards,
Shubham
hi,
if you are receiving a string with the exact format you describe then the following code will turn it into a Julian date - by this I understand a 5 digit figure, the first two digits being YY followed by the number of the day in the year (is this what you are after?):
=mid(text(year(makedate(mid(vDate,7,4)))),3,2) & num((makedate(mid(vDate,7,4),mid(vDate,4,2),mid(vDate,1,2)) - makedate(mid(vDate,7,4)))+1,'000')
Try this which will evaluate the incoming text string as a timestamp:
timestamp#( fieldname,'DD/MM/YY HH:MM:SS') as JulianField
Regards,
Gordon
Fulqenzio,
Gordon is correct, but try using hours:minutes:second in lower case.
timestamp#( fieldname,'DD/MM/YY hh:mm:ss') as JulianField
- Sridhar
The reason is that: If you type the minute format specially in upper case it will print the month in place of the minute.