This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying to combine a date and time field together into one:
I tried using:
timestamp#(Job_Date & ' ' & Job_Time,'DD/MM/YYYY hh:mm:ss') to get both of them in one field but this function seems to convert the date into numbers and keeps the time format strangely.
Any idea how I can get around this please?
timestamp#(Job_Date & ' ' & Job_Time,'DD/MM/YYYY hh:mm:ss')
which uses your default timestamp Format.
Hole this helps
View solution in original post
if it is Date() and Time() you can use timestamp(Date+time). If you can not get it in time and date with the # functions use maketime/date.
Thanks for your reply. The original data is already in Date and Time format. Do you have a practical example of what to try with my two fields above?
You were close with your first attempt. The internal value for a datetime is an integer day since dec 31 1899 and time is represented as a fraction. Today at noon is 42027.5
add in a timestamp() formatting function to get the result you want.
timestamp(timestamp#(Job_Date & ' ' & Job_Time,'DD/MM/YYYY hh:mm:ss'))
Is this what you are trying to achieve? PFA
Ah now I understand! Thank you so much Marco and Jonas!
Yes thank you Sunindia!
I have one more problem
When I use a certain date field as part of time stamp it gives me the date and time from the date field.
When I add a time field to it, suddenly I get no results even though the time field is populated with values!
The time field is showing up. Isn't this what you want?