Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have date field like this 20220728 (YYYY MM DD) and time field like this 220214 (hhmmss) so now I want convert date time into time stamp format like this DD/MM/YYYY hh:mm:ss
Timestamp(Date#(DateField,'YYYYMMDD')+Time#(TimeField,'hhmmss'),'DD/MM/YYYY hh:mm:ss')
@Vinni2000 one more option
=timestamp(Timestamp#(Date&Time,'YYYYMMDDhhmmss'),'DD/MM/YYYY hh:mm:ss')