read and transforming

[userid128223]

i have field like below. I need to convert it in promper format so i can do calcualtion on it. like convert from one time zone to another.

Date Time:

02/21/2017 22:02:33          //  I see date & time left alligned.

This is not being read as proper format hence i cannot do any conversion.

[kamal_sanguri]

Coming on to your second question, where you want to subtract 4 hours from your time.

Replace Now() with your expression to calculate date/time

-- Date(Now()-(240/24/60),'DD/MM/YY hh:mm:ss')

**240 represents number of minutes you want to subtract.

EDIT

1.) Please change the Date format  'DD/MM/YY hh:mm:ss' inside the date function as per your need.

2.) corrected date format used upper case characters to show time.

[kamal_sanguri]

=date(now()-date(date#('04:00:00', 'hh:mm:ss')),'DD/MM/YY hh:mm:ss')