+ Start a Discussion
hari azmeera 8hari azmeera 8 

Extract date and time seperately from a date/time field

Rupali PophaliyaRupali Pophaliya
You can use below formulas to extract date and time separately:

DateFormula:  DATEVALUE( YourDateTimeField__c )
TimeFormula: MID(TEXT(YourDateTimeField__c ), 12, 5)
Roshan Rana 10Roshan Rana 10
But it give +GMT
Sourav Mitra ThakurSourav Mitra Thakur
Try datetimefield__c.date() for date extraction