query

A

ATAG

New member
Local time
Today, 18:58
Joined
Jul 21, 2015
Messages
2
I have a problem when using converting date from Gregorian to Hijri in query field The new Higri date became " text type" .So i can't make yearly sum
please help me
 
Try CDate("HijriDateAsText") or CDate(HijriDateVariable)

CDate() Converts Text represented DATEs to real DATEs

Cheers!
Goh
 
Last edited:
You must log in or register to reply here.

Similar threads

E
Birthday Report
Replies
12
Views
424
Gasman
Gasman
A
Search button for more than one field search
Replies
3
Views
229
Ken Sheridan
Ken Sheridan
mloucel
Solved Interesting QUERY problem
Replies
11
Views
792
mloucel
mloucel
P
Extract Year From Control On Form
Replies
7
Views
452
arnelgp
arnelgp
C
Crosstab query that uses Form field as criteria
Replies
14
Views
1,127
Ken Sheridan
Ken Sheridan

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom