Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can you please help me to get two separate columns
add 4:30:00(hh:mm:ss) to the below date and time format.
16/06/2018 23:22:48
another column with Subtract 4:30:00(hh:mm:ss) to the below date and time format.
16/06/2018 23:22:48
Thanks,
Gowtham
May be this
TimeStamp(Date#('16/06/2018 23:22:48', 'DD/MM/YYYY hh:mm:ss') + MakeTime(4, 30), 'DD/MM/YYYY hh:mm:ss') as StartTime,
TimeStamp(Date#('16/06/2018 23:22:48', 'DD/MM/YYYY hh:mm:ss') - MakeTime(4, 30), 'DD/MM/YYYY hh:mm:ss') as EndTime
May be this
TimeStamp(Date#('16/06/2018 23:22:48', 'DD/MM/YYYY hh:mm:ss') + MakeTime(4, 30), 'DD/MM/YYYY hh:mm:ss') as StartTime,
TimeStamp(Date#('16/06/2018 23:22:48', 'DD/MM/YYYY hh:mm:ss') - MakeTime(4, 30), 'DD/MM/YYYY hh:mm:ss') as EndTime
Hi,
Try this:
vData=16/06/2018 23:22:48
vInterval= 4:30:00
vDataIni=Date(vData-vInterval)
vDataEnd=Date(vData+vInterval)